Thread: pgAdmin 4 - How to set auto increment primary key
How to set a auto increment primary key on pgAdmin 4?! Best regards -- View this message in context: http://postgresql.nabble.com/pgAdmin-4-How-to-set-auto-increment-primary-key-tp5922468.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Fri, Sep 23, 2016 at 10:41 AM, killermouse <killermouse@gmail.com> wrote: > How to set a auto increment primary key on pgAdmin 4?! Add a column to your table, select of the serial data types, and flip the Primary Key switch. See the attached screenshot for an example. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Attachment
Thank you for your reply. I can't find the serial data type! As you can see in picture <http://postgresql.nabble.com/file/n5922472/pgadmin4.png> Best regards -- View this message in context: http://postgresql.nabble.com/pgAdmin-4-How-to-set-auto-increment-primary-key-tp5922468p5922472.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Fri, Sep 23, 2016 at 11:02 AM, killermouse <killermouse@gmail.com> wrote: > Thank you for your reply. > > I can't find the serial data type! > > As you can see in picture > <http://postgresql.nabble.com/file/n5922472/pgadmin4.png> Are you using an old version? There was a bug that caused that that was fixed some time back: https://redmine.postgresql.org/issues/1393 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Thank you -- View this message in context: http://postgresql.nabble.com/pgAdmin-4-How-to-set-auto-increment-primary-key-tp5922468p5922475.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.