/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 vote161 views3 answers
Sql count condition
SQL
20 votes172 views3 answers
SQL query rename table
SQL
0 vote233 views1 answer
Check user sql password from command line
SQL
0 vote219 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
2 votes173 views1 answer
Mysql sysdate - 1 day
SQL
1 vote182 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote184 views1 answer
SQL Integer devision
SQL
7 votes171 views2 answers
Mysql get year from date
SQL
3 votes220 views1 answer
Oracle function
SQL
0 vote191 views1 answer
Sql date time query find
SQL

Share