/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 vote108 views1 answer
Apex for oracle 11g
SQL
1 vote104 views1 answer
Create sample data postgresql
SQL
1 vote108 views2 answers
Sql server add time to date
SQL
0 vote103 views1 answer
Oracle for loop on list
SQL
0 vote117 views1 answer
SQL check if record exist
SQL
1 vote99 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote65 views1 answer
Check sql query executed wp
SQL
1 vote152 views2 answers
Sql split string by space
SQL
0 vote116 views2 answers
Coursera spark sql max count
SQL
13 votes105 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL

Share