Re: [GENERAL] Adding Records With SERIAL Primary Key

2005-05-03 Thread Rich Shepard
On Tue, 3 May 2005, Scott Marlowe wrote: When loading in data using the copy command, one can set the columns to be copied, and the system will insert the serial value for you if you leave that column out of the list. Scott, Aha! I thought this would be the case, but I was not sure. Many thanks,

Re: [GENERAL] Adding Records With SERIAL Primary Key

2005-05-03 Thread Scott Marlowe
On Tue, 2005-05-03 at 11:58, Rich Shepard wrote: >I may have missed this in the docs; if so, please tell me where to find the > answer there. If not, I still need to learn how to resolve this situation. > >The database schema has been designed and the tables are ready to be > created. Once

[GENERAL] Adding Records With SERIAL Primary Key

2005-05-03 Thread Rich Shepard
I may have missed this in the docs; if so, please tell me where to find the answer there. If not, I still need to learn how to resolve this situation. The database schema has been designed and the tables are ready to be created. Once they exist, I want to load data into the tables in batch mode