/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 vote149 views1 answer
Not equal to blank in mysql
SQL
0 vote152 views1 answer
How to add timestamp column in mysql
SQL
11 votes149 views2 answers
MySQL DISTINCT
SQL
0 vote152 views1 answer
View to table
SQL
0 vote152 views1 answer
Less than and between in sql query
SQL
0 vote152 views1 answer
Every Derived yable must have its own alias
SQL
3 votes155 views2 answers
Postgres alter table owner
SQL
0 vote144 views1 answer
Can we rollback in sql
SQL
1 vote169 views3 answers
Postgresql crete view
SQL
0 vote180 views1 answer
000webhost database values insert
SQL

Share