/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 vote334 views1 answer
Sql find gaps in date ranges
SQL
0 vote306 views1 answer
Postgres sequence name
SQL
2 votes314 views4 answers
Check timezone of mysql database
SQL
3 votes286 views1 answer
Oracle apex warning message
SQL
20 votes305 views5 answers
Sql show tables
SQL
0 vote310 views1 answer
Sql sum if
SQL
0 vote279 views1 answer
Take sql dump in to file
SQL
1 vote288 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote330 views1 answer
Add new column in sql with foreign key
SQL
0 vote238 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL

Share