/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 vote124 views1 answer
Insert or update sql query
SQL
0 vote142 views1 answer
Nodejs sql get one to many relationship as array
SQL
9 votes138 views3 answers
Find all tables with column name
SQL
0 vote165 views1 answer
Migrations.RunSQL
SQL
0 vote120 views1 answer
Get first name and last name from full name string in SQL
SQL
1 vote126 views1 answer
Get rows affected mysql python
SQL
0 vote131 views1 answer
Match end of string regex sql
SQL
6 votes123 views4 answers
Sqlite drop table
SQL
0 vote165 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
2 votes136 views1 answer
How to delete all duplicate items in mysql
SQL

Share