/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 vote227 views1 answer
Running mysql from bash sc
SQL
0 vote221 views1 answer
Create a sql server database programmatically
SQL
0 vote224 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
2 votes200 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote215 views1 answer
How to export only procedures mysql
SQL
0 vote212 views1 answer
Mysql update even / odd rows
SQL
0 vote228 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote268 views2 answers
How to check if a column exists in a SQL Server table?
SQL
2 votes219 views1 answer
Oracle to_char number format percentage
SQL
1 vote209 views1 answer
Select inside insert query
SQL

Share