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 information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly