/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 vote309 views1 answer
Guid string to binary better
SQL
0 vote289 views1 answer
AddEntityFrameworkSqlite
SQL
1 vote352 views1 answer
How to set up a trigger in sql
SQL
0 vote296 views1 answer
Postgres 11 add primary key
SQL
8 votes302 views1 answer
Mac restore mysql database command line
SQL
1 vote297 views1 answer
Sql try catch
SQL
0 vote304 views1 answer
Odd record sql query
SQL
0 vote296 views1 answer
Inner joint
SQL
9 votes322 views1 answer
No sql
SQL
2 votes356 views1 answer
Mysql select true or false
SQL

Share