/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 vote217 views1 answer
How to find the most occuring in SQL
SQL
5 votes171 views4 answers
Sql check
SQL
1 vote129 views1 answer
Create procedure with encryption
SQL
2 votes130 views1 answer
Check isolation level in mysql
SQL
0 vote161 views1 answer
Select top values sql
SQL
14 votes201 views1 answer
How to export db from mysql
SQL
1 vote124 views1 answer
PLS-00225 type
SQL
0 vote138 views1 answer
Create table using the clause with as
SQL
-2 votes144 views3 answers
Sqlite reset autoincrement
SQL
0 vote145 views1 answer
What is mysql_pconnect
SQL

Share