Re: Database conversion type serial question

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Database conversion type serial question
Дата
Msg-id
17944.1205507851@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Database conversion type serial question Carol Walter <walterc@indiana.edu>
Re: Database conversion type serial question Tom Lane <tgl@sss.pgh.pa.us>
Carol Walter  writes:
> Can I designate a column not  
> previously defined as serial to serial.

"serial" is not really a type.  It's just a convenience macro for
creating a sequence and setting the column's default expression.
So what you do is perform those steps manually.  See
http://www.postgresql.org/docs/8.2/static/datatype-numeric.html#DATATYPE-SERIAL

			regards, tom lane
В списке pgsql-admin по дате отправления
От: Carol Walter
Дата:
От: Marc Fromm
Дата:
Сообщение: howto restore from pg_dumpall
FAQ