On Sun, Mar 04, 2001 at 05:22:46PM +0000, some SMTP stream spewed forth: > Hi all, > > Is there any SQL statement to PostgreSQL that will allow me to insert rows > with a specified value for the SERIAL value. I know this is not what you > want to do normally, but I'm trying to provide a kind of general export and > import function to a generic database. Since there exists foreign key values > in instances of other tables that point into field values for a table that > has a SERIAL id, I'd like to somehow import all this data and continue using > the SERIAL functionality for the highest value of the id fields. I think what you want is insert into table (<serial_col>, <whatever>,...) values (...); dan > > Ian > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
