Zoltan Tomory wrote:

It’s been a while since I used SQL. SQL is not identical to e.g. MySQL interpretation.

I created a database using CREATE SCHEMA CAT1;

I thought I used to use USE CAT1; to get into a database, but MonetDB did not like it.

No, you simply connect to a server dedicated to handling a specific database. See the examples in http://monetdb.cwi.nl/projects/monetdb/SQL/QuickTour/index.html and http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/MAPI-Client.html#MA...

I confirmed creation of the schema with SELECT * FROM SCHEMAS;

What am I doing wrong?

Zoltan Tomory

zoltan.tomory@mobot.org <mailto:zoltan.tomory@mobot.org>

------------------------------------------------------------------------

------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/

------------------------------------------------------------------------

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users