Postgresql Basic Commands
1)\l -> List of all databases(***)
2)create database koti; -> Cresating new database
3)drop database koti; -> Drop the database
3)\c koti; -> Use database(***)
4)create table employee(id int primary key not null,name varchar(23),phone_no int); -> Create table
5)\d -> List of all tables(***)
6)\d employee -> See the particular table(***)
7)insert into employee (id,name,phone_no) VALUES (1, 'koti', 23);
8)\q -> Quit the Postgresql
1)\l -> List of all databases(***)
2)create database koti; -> Cresating new database
3)drop database koti; -> Drop the database
3)\c koti; -> Use database(***)
4)create table employee(id int primary key not null,name varchar(23),phone_no int); -> Create table
5)\d -> List of all tables(***)
6)\d employee -> See the particular table(***)
7)insert into employee (id,name,phone_no) VALUES (1, 'koti', 23);
8)\q -> Quit the Postgresql
Comments
Post a Comment