Using sequences in SQL text files

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: Lew
Дата:
Сообщение: Re: Auto incrementing primary keys
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Using sequences in SQL text files