/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

2 votes324 views1 answer
Sql count having
SQL
0 vote363 views1 answer
Mysql average from two table
SQL
2 votes347 views2 answers
Mysql count rows returned
SQL
0 vote336 views1 answer
Postgres row expiration
SQL
0 vote359 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
1 vote337 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
1 vote328 views2 answers
Create table if not exist
SQL
0 vote311 views1 answer
Replace multiple string in query sql
SQL
1 vote332 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote346 views1 answer
Procedure excute monthly oracle
SQL

Share