Re: system maintained keys - Mailing list pgsql-sql

From Josh Berkus
Subject Re: system maintained keys
Date
Msg-id web-151189@davinci.ethosmedia.com
Whole thread Raw
In response to system maintained keys  ("Stefan Lindner" <lindner@visionet.de>)
List 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 by date:

Previous
From: "Stefan Lindner"
Date:
Subject: system maintained keys
Next
From: "Aasmund Midttun Godal"
Date:
Subject: Re: oid's in views.