Using sequences in SQL text files

Поиск
Список
Период
Сортировка
Искать
От
HHB
Тема
Using sequences in SQL text files
Дата
Msg-id
15561422.post@talk.nabble.com
Список
Дерево обсуждения
Using sequences in SQL text files HHB <hubaghdadi@yahoo.ca>
Re: Using sequences in SQL text files Raymond O'Donnell <rod@iol.ie>
Re: Using sequences in SQL text files Lone Wolf <hubaghdadi@yahoo.ca>
Re: Using sequences in SQL text files Richard Huxton <dev@archonet.com>
Re: Using sequences in SQL text files brian <brian@zijn-digital.com>
Re: Using sequences in SQL text files HHB <hubaghdadi@yahoo.ca>
Re: Using sequences in SQL text files Thomas <tburdairon@entelience.com>
Re: Using sequences in SQL text files intelforum@subtropolix.org

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
Дата:
От: Raymond O'Donnell
Дата:
FAQ