/SQL/Postgres autoincrement primary key

Postgres autoincrement primary key

Postgres autoincrement primary key

CREATE TABLE epictable
(
    mytable_key    serial primary key,
    moobars        VARCHAR(40) not null,
    foobars        DATE
);

0

Source: stackoverflow.com

Auto increment psql not primary key

CREATE SEQUENCE cateogry_id_seq;
ALTER TABLE category ALTER COLUMN category_id SET DEFAULT nextval('cateogry_id_seq');

-1

Source: stackoverflow.com

Similar codes

0 vote310 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote300 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote343 views1 answer
Mysql faster delete
SQL
5 votes309 views1 answer
How to check port number for postgresql
SQL
3 votes330 views1 answer
Uppercase and lowercase in sql
SQL
0 vote331 views1 answer
Insert set mysql
SQL
0 vote298 views1 answer
Change data type in mysql
SQL
0 vote291 views0 answer
SQL
3 votes301 views4 answers
Show columns from table
SQL
0 vote321 views1 answer
SQL authentication error
SQL

Share