Setting auto increment id in Postgres with Navicat

postgresql navicat
Nick Parsons picture Nick Parsons · Dec 1, 2014 · Viewed 7.6k times · Source

I'm rather new to Postgres and Navicat is the only fully functional GUI that I've come across. That said, I'm trying to implement a simple auto increment for an id. Navicat doesn't seem to support bigserial or serial, or have anything in place to specify a primary key w/ auto increment. Any thoughts?

Answer

hzandi picture hzandi · Feb 2, 2017

you should make a sequence default value

Navicat Menu -> Others -> Sequence -> (choose table and column) -> save "user_id_plus1"

and set default value for id column with 

nextval('user_id_plus1'::regclass)

Related questions

How can i get a count(*) of all the columns in a table? Using PostgreSql

I have bunch of tables where several of them have hundreds of columns. I need to get a count of non-null values for each column and I've been doing it manually. I would like to figure out a way to …

Read More
PostgreSQL: column "rolcatupdate" does not exist error?

I installed PostgreSQL on new server. When I try create new table or new data base, get this error: column "rolcatupdate" does not exist. How can I fix it?

Read More
PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More