SQL for beginners 1

create db

CREATE DATABASE contacts;

create table

\connect contacts
CREATE TABLE friends(firstname TEXT, lastname TEXT phone TEXT);

delete db

DROP DATABASE contacts;

delete friend

DELETE FROM friends WHERE firstname = 'david';

insert friend

INSERT INTO friends(firstname, lastname, phone) VALUES ('david', 'aragon', '1234567890');

quit

\q

select all

SELECT * FROM friends;

show dbs

\l

start

psql -h localhost