/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 vote109 views1 answer
Check if a word appears at the end sql query
SQL
0 vote141 views1 answer
Mariadb used space
SQL
1 vote133 views1 answer
Oracle columns table
SQL
0 vote118 views2 answers
How to tun mysql on ubunto
SQL
6 votes109 views2 answers
Oracle
SQL
0 vote116 views1 answer
Addition of 2 column value in mysql
SQL
0 vote158 views1 answer
Mysql failed to login as root@localhost
SQL
12 votes122 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote117 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote111 views1 answer
Mysql autoincrement valor inicial
SQL

Share