Geeks With Blogs
Sathya Narayanan Srinivasan .NET Developer
While creating the table you can see a data type called Serial or BigSerial (Note that these two options will not be available when you modify a column thats already created. You can see these options only when you create a column in pgAdmin III)

In create table script you need to give the SQL command like this :-
"ID" serial NOT NULL
Posted on Sunday, August 26, 2012 5:52 PM | Back to top


Comments on this post: Auto increment in postgres

# Auto increment in postgres
Requesting Gravatar...
initially while creating tables it will show as "ID" serial not null
Left by Wordpress developers on Aug 27, 2012 12:13 PM

# : Auto increment in postgres
Requesting Gravatar...
initially when we create a table it will show as "ID" serial NOT NULL its true
Left by Prestashop modules on Aug 27, 2012 5:20 PM

Your comment:
 (will show your gravatar)


Copyright © sathya | Powered by: GeeksWithBlogs.net