Re: system maintained keys

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: system maintained keys
Дата
Msg-id web-151189@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на system maintained keys  ("Stefan Lindner" <lindner@visionet.de>)
Список pgsql-sql
Stefan,

> Is there any way to get system maintained keys from postgres? e.g. to
> have a table with a primary key column (varchar or int) and let
> postgres
> chose the next unique value for this column?

Please address future questions of this type to the PGSQL-NOVICE list.
PGSQL-SQL is for more advanced SQL issues.

Yes, you can do this easily,  Please see:
http://www.postgresql.org/idocs/index.php?datatype.html#DATATYPE-NUMERIC
Look at secion 3.1.1 on the page.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


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

Предыдущее
От: "Stefan Lindner"
Дата:
Сообщение: system maintained keys
Следующее
От: "Aasmund Midttun Godal"
Дата:
Сообщение: Re: oid's in views.