Using sequences in SQL text files

From: HHB <hubaghdadi(at)yahoo(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Using sequences in SQL text files
Date: 2008-02-19 15:43:09
Message-ID: 15561422.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-02-19 15:51:46 Re: Using sequences in SQL text files
Previous Message Erik Jones 2008-02-19 15:30:12 Re: questions about very large table and partitioning