/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 vote217 views1 answer
The fetch keyword oracle
SQL
2 votes192 views1 answer
Oracle calculated column
SQL
0 vote261 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote248 views1 answer
Sql tablo sp
SQL
2 votes235 views1 answer
Oracle kill session by sql_id
SQL
8 votes193 views3 answers
Oracle auto_increment
SQL
0 vote190 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote207 views3 answers
Duplicate row mysql
SQL
4 votes188 views2 answers
Postgres update single column
SQL
0 vote161 views1 answer
Mariadb list tables
SQL

Share