Jan
29
2013

Basic PostgreSQL Shell Commands

Create a database: createdb phidatabase Connect to database: psql phidatabase \l - List databases \d - List tables in database \h - help command \? help on internal lash command \g - execute query \q - quit Basic SQL Queries: CRAETE TABLE phitable (id int, data varchar(200), datecraeted date); INSERT INTO phitable VALUES ('1', 'somevalue', '9-9-2013'); SELECT * FROM phitable; UPDATE phitable SET id=2, data = 'some data' WHERE id = 1; DELETE FROM phitable WHERE = id = 2; DROP TABLE phitable;

Calendar

<<  June 2020  >>
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345

View posts in large calendar