Mayuresh, First, beginner's questions belong on the PGSQL-NOVICE list.
> could anyone tell me how to make a primary key to AUTO INCREMENT. The > document is not exactly very explainatory about it :) No, it is quite clear. See: http://www.postgresql.org/idocs/index.php?datatype.html section 3.1.1 I can't imagine how it would be more clear. -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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]