[MonetDB-users] COPY with AUTO_INCREMENT column

Romulo Goncalves R.A.Goncalves at cwi.nl
Fri Dec 7 15:55:46 CET 2007

Maybe some documentation will help you.

To create the table with auto-increment column which is also a primary key:

To do the copy:

There you have the syntax tree that will help you to construct correctly 
your queries ;)


Venks wrote:
> Hi,
> How can I use COPY to load data into a table with a AUTO_INCREMENT
> column? Just to clarify, the AUTO_INCREMENT column would be the
> PRIMARY KEY by default and doesn't have any corresponding data in the
> data file.
> Thanks,
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: 
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users

More information about the users-list mailing list