/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 vote160 views1 answer
Leftjoin in sql
SQL
0 vote213 views1 answer
Alter table name including schema
SQL
0 vote125 views1 answer
Difference between cross apply and inner join
SQL
0 vote299 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
11 votes318 views4 answers
Round in sql
SQL
0 vote133 views2 answers
Find Overlapping sql
SQL
2 votes144 views2 answers
Mysql count rows returned
SQL
24 votes156 views4 answers
Mysql datetime
SQL
0 vote140 views1 answer
Google sheets filter rows above current cell
SQL
0 vote147 views1 answer
Oracle sql add column auto generated value
SQL

Share