/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

2 votes339 views1 answer
Tcl in sql
SQL
0 vote327 views1 answer
Mysql concatenate select results
SQL
0 vote290 views1 answer
Sql date between one week
SQL
0 vote293 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote285 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote297 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote302 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote236 views1 answer
'0000-00-00' for column '
SQL
0 vote228 views1 answer
Sql table to store status
SQL
0 vote262 views1 answer
Sql select non unique
SQL

Share