/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

1 vote122 views1 answer
Oracle update with sequence
SQL
61 votes198 views6 answers
Mysql add column
SQL
0 vote145 views1 answer
SQL Where-Klausel
SQL
-1 vote130 views1 answer
Auto increment psql not primary key
SQL
0 vote117 views1 answer
Mysqlimport
SQL
1 vote108 views1 answer
Pv mysql import
SQL
3 votes120 views3 answers
Restart mysql mac
SQL
4 votes108 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
2 votes111 views1 answer
Sqlplus clear screen
SQL
1 vote120 views1 answer
Oracle turn off constraint
SQL

Share