Inserting values into a SERIAL field

Поиск
Список
Период
Сортировка
От Ian deSouza
Тема Inserting values into a SERIAL field
Дата
Msg-id GRuo6.14992$7Y1.1513585@newsread2.prod.itd.earthlink.net
обсуждение исходный текст
Ответы Re: Inserting values into a SERIAL field
Список pgsql-general
Hi all,

Is there any SQL statement to PostgreSQL that will allow me to insert rows
with a specified value for the SERIAL value. I know this is not what you
want to do normally, but I'm trying to provide a kind of general export and
import function to a generic database. Since there exists foreign key values
in instances of other tables that point into field values for a table that
has a SERIAL id, I'd like to somehow import all this data and continue using
the SERIAL functionality for the highest value of the id fields.

Ian




В списке pgsql-general по дате отправления:

Предыдущее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: INSERT ... RETURNING as Oracle
Следующее
От: "Eric G. Miller"
Дата:
Сообщение: Re: interval question