[MonetDB-users] inserting into default schema?
sesquile at gmail.com
Wed Dec 5 07:54:24 CET 2007
On Nov 30, 2007 3:01 PM, Niels Nes <Niels.Nes at cwi.nl> wrote:
> 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?
More information about the users-list