/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 vote175 views1 answer
Sqldf change user
SQL
4 votes175 views4 answers
Sqlite describe table
SQL
0 vote192 views1 answer
Sql server change schema of a table
SQL
3 votes184 views1 answer
Oracle list dates without weekends
SQL
1 vote176 views2 answers
Replace text in sql
SQL
3 votes189 views1 answer
Define REGEXP?
SQL
0 vote199 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote193 views1 answer
Oracle query to find schema you are working on
SQL
0 vote182 views1 answer
Sql server user permissions and roles
SQL
0 vote213 views1 answer
Mysql faster delete
SQL

Share