/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

4 votes256 views2 answers
Select first and last row mysql
SQL
13 votes266 views5 answers
Sql default
SQL
0 vote280 views1 answer
Sql filter rows with condition
SQL
0 vote265 views1 answer
Codigo crear tablas sql server
SQL
2 votes285 views2 answers
Oracle create table if not exists
SQL
0 vote265 views1 answer
Run mssql server terminal
SQL
1 vote254 views1 answer
Sql server find tables referenced foreign key
SQL
7 votes251 views3 answers
Postgre describe table
SQL
0 vote268 views1 answer
Oracle sql drop table
SQL
1 vote266 views1 answer
Get parameter value in mysql trigger
SQL

Share