/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

1 vote185 views1 answer
Show table columns
SQL
2 votes195 views1 answer
Oracle find constraints referencing a table
SQL
1 vote135 views1 answer
Insert into sql
SQL
1 vote184 views1 answer
Regular expression in sql server
SQL
7 votes285 views2 answers
Sql empty table
SQL
2 votes182 views1 answer
Oracle cpu per session
SQL
5 votes196 views2 answers
Postgres update with if condition query
SQL
0 vote142 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
51 votes294 views6 answers
Change column name sql
SQL
6 votes202 views4 answers
Remove spaces sql server
SQL

Share