/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

0 vote194 views1 answer
Mysql group by range
SQL
1 vote171 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
1 vote171 views1 answer
Round function in sql oracle
SQL
5 votes188 views2 answers
Oracle find all tables with column name
SQL
0 vote325 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
8 votes173 views1 answer
Oracle add months to sysdate
SQL
5 votes175 views2 answers
Mysqldump password
SQL
0 vote233 views1 answer
Mysql wsrep ls
SQL
0 vote196 views2 answers
Import .sql into postgres db command
SQL
0 vote219 views1 answer
Stop and start mysql
SQL

Share