Re: Using sequences in SQL text files - Mailing list pgsql-general

HHB wrote:
> Hi.
> I have sequence for each table in my database.
> In order to populate same data in the database, I created some SQL text
> files.
> ---
> insert into categories values (id value from sequence, '..', '...');
> insert into books values (id value from sequence, '..', '...', '..', fk to
> category id);

If they are of SERIAL type then they'll use their sequence by default:

INSERT INTO my_table (id, a, b) VALUES (DEFAULT, 'abc', 123);

Otherwise you can use the currval/nextval() functions:

INSERT INTO my_table (id, a, b) VALUES (nextval(<SEQUENCE-NAME>), 'abc',
123);

--
   Richard Huxton
   Archonet Ltd