/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 vote201 views1 answer
What is top n result in sql
SQL
3 votes194 views2 answers
Sqlite print all column names
SQL
2 votes188 views2 answers
Sql query to copy data from one column to another
SQL
1 vote193 views1 answer
Sql insert for each distinct value
SQL
0 vote188 views1 answer
Show all mongodb
SQL
0 vote188 views1 answer
When mysql server would not work in xampp
SQL
1 vote207 views1 answer
Oracle sequence last_number
SQL
0 vote200 views1 answer
Mysql locate
SQL
1 vote236 views1 answer
Oracle drop temporary table
SQL
0 vote218 views1 answer
Vs 2019 connect to local mysql database
SQL

Share