basic psql commands

basic-psql.txt

-- \l gives the details of databases in psql.

// create a database
CREATE DATABASE test;

//close the prompt and start again.

// enter db name to be test

// to create a table
CREATE TABLE person (
id BIGSERIAL NOT NULL PRIMARY KEY,
name VARCHAR(100) NOT NULL,
country VARCHAR(100) NOT NULL );

-- \d and \dt gives tables info on current db.

// to insert some data in the table.
INSERT INTO person(name, country) VALUES ('ashish', 'India');
INSERT INTO person(name, country) VALUES ('ash', 'USA');

// get data
SELECT * FROM person;

// update a row
UPDATE person SET name = 'anthony' WHERE id=3;

// delete a row
DELETE FROM person where id=2;