/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 vote167 views1 answer
Postgres select as csv
SQL
2 votes185 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote158 views1 answer
Postgresql import data from csv
SQL
0 vote168 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote172 views4 answers
Mysql select bottom 10 rows
SQL
4 votes179 views1 answer
Search column by name mysql
SQL
0 vote162 views1 answer
Disableforiegn key check
SQL
10 votes170 views4 answers
Sql pagination
SQL
0 vote179 views1 answer
Liquibase update row
SQL
28 votes191 views6 answers
Sql update
SQL

Share