/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 vote386 views1 answer
Sql alter column name sql server
SQL
17 votes412 views3 answers
Postgresql list users
SQL
0 vote353 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote389 views1 answer
Mysql faster delete
SQL
0 vote399 views1 answer
Querry mysql by 2 columns
SQL
0 vote380 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote361 views2 answers
Wordpress change url in database
SQL
1 vote328 views2 answers
Into sql
SQL
0 vote374 views1 answer
Sql remove decimal places
SQL
0 vote374 views1 answer
Sql insert query list of dictionaries
SQL

Share