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

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);
---
Is it possible to do so?
How to use a sequence in such text files?
Thanks.
--
View this message in context: http://www.nabble.com/Using-sequences-in-SQL-text-files-tp15561422p15561422.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Lew
Date:
Subject: Re: Auto incrementing primary keys
Next
From: Raymond O'Donnell
Date:
Subject: Re: Using sequences in SQL text files