DBA Hub

📋Steps in this guide1/1

Create/drop table in postgres

-- Create a simple table postgres=# Create table member_table ( mem_id integer, member_name varchar(100) , mobile integer not null); CREATE TABLE

postgresql configurationintermediate
by PostgreSQL
12 views
1

Create/drop table in postgres

-- Create a simple table postgres=# Create table member_table ( mem_id integer, member_name varchar(100) , mobile integer not null); CREATE TABLE -- Create table with primary key postgres=# Create table member_table ( mem_id integer primary key, member_name varchar(100) , mobile integer not null); CREATE TABLE -- Create table under particular tablespace postgres=# Create table member_table ( mem_id integer primary key, member_name varchar(100) , mobile integer not null) tablespace pg_production_ts; CREATE TABLE -- Create table with unique constraint postgres=# Create table member_table ( mem_id integer, member_name varchar(100) , mobile integer not null , constraint mem_id_cons unique(mem_id)); CREATE TABLE -- Create temporary table: -- Drop table

Code/Command (click line numbers to comment):

1
2
3
4
5
postgres=#
Create temporary table member_table ( mem_id integer primary key, member_name varchar(100) , mobile integer not null) tablespace pg_default;
CREATE TABLE
postgres=#
drop table member_table;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!