5 Dec
2007
5 Dec
'07
6:54 a.m.
On Nov 30, 2007 3:01 PM, Niels Nes
On Fri, Nov 30, 2007 at 02:52:34PM -0700, m h wrote:
If I create a table, by default it goes into the "tmp" schema. The "tmp" schema isn't intended for such usage. Its to store 'temporary' tables, ie those created using.
create temp table x
With a normal login to MonetDB/SQL using the monetdb user, you will end up in the sys schema, ie new tables are created inside this one.
Anyway if you don't want that, then you should create your own schema and user(s) etc.
Does the JDBC driver store newly created tables in the tmp schema? sys? Some other default? -matt