Maybe some documentation will help you. To create the table with auto-increment column which is also a primary key: http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Table-Definition.ht... To do the copy: http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Data-Manipulation.h... There you have the syntax tree that will help you to construct correctly your queries ;) Regards, Romulo 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users