Answers for "primary key postgresql"

SQL
1

postgresql primary key

CREATE TABLE users (
  id SERIAL PRIMARY KEY, # Primary key
  username VARCHAR(50),
  col_name3 data_type,
  …
);

CREATE TABLE posts (
	id SERIAL PRIMARY KEY, # Primary key
	url VARCHAR(200),
    user_id INTEGER REFERENCES users(id), # foreign key
    col_name3 data_type,
  	col_name4 data_type key_type,
	…
);
Posted by: Guest on October-26-2021
0

create table postgresql primary key

CREATE TABLE TABLE (
	column_1 data_type PRIMARY KEY,
	column_2 data_type,
	…
);
Posted by: Guest on April-24-2020

Code answers related to "primary key postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language