/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

1 vote142 views1 answer
Select if then postgresql
SQL
8 votes159 views1 answer
Oracle add datafile to tablespace
SQL
0 vote154 views1 answer
Sql output select
SQL
2 votes146 views1 answer
Mysql clear screen
SQL
3 votes146 views1 answer
Sql is not like
SQL
1 vote174 views1 answer
Drop column if exists sql server
SQL
94 votes199 views4 answers
Create database postgres
SQL
0 vote163 views1 answer
Using distinct and count together in sql
SQL
4 votes141 views4 answers
Date less than in sql
SQL
0 vote153 views1 answer
Sqlite get date only
SQL

Share