/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 vote349 views1 answer
Postrgres trunc
SQL
0 vote344 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
4 votes315 views1 answer
Wilayah indonesia sql
SQL
0 vote357 views1 answer
Offset in postgresql example
SQL
5 votes329 views1 answer
How to check nls format in oracle
SQL
0 vote415 views1 answer
Mysql show schema
SQL
0 vote359 views1 answer
Get clob size oracle
SQL
0 vote411 views1 answer
Redshift running queries
SQL
0 vote313 views1 answer
Mysql show foreign keys column
SQL
0 vote342 views1 answer
Consulta alias con inner join
SQL

Share