/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

3 votes180 views2 answers
Sqlite print all column names
SQL
0 vote209 views1 answer
Rabbitmq service not starting
SQL
3 votes170 views1 answer
Oracle drop user
SQL
0 vote204 views1 answer
Set mysql socket file docker windows
SQL
0 vote173 views2 answers
How to display enum value sql server
SQL
0 vote159 views4 answers
Mysql select bottom 10 rows
SQL
0 vote166 views2 answers
Sql auto update dupdated_at
SQL
3 votes121 views1 answer
If 0 return null else return query mysql
SQL
0 vote200 views1 answer
Day of the week sqlite
SQL
0 vote246 views1 answer
Show mysql account privilleges
SQL

Share