Useful postgresql commands

useful_psql_commands.sql

/* Basic viewing the structure commands */
\c database_name --connect to a database.
\dt --view the tables. this filters out non-table relations.
\d  --view the tables. Includes non-table relations.
\d tablename --view the columns of the table.


/* Create a table and import from a csv into that table. */
CREATE TABLE employees (
  id SERIAL, 
  first_name varchar(100),
  last_name varchar(100),
  dob date, 
  email varchar(255),
  PRIMARY KEY (id)
);

\COPY employees(first_name, last_name, dob, email)
FROM '~/employees.csv'
DELIMITER ','
CSV HEADER;


/* Dumping a psql database to a tar file */
pg_dump -U postgres_username -h localhost -W -F t databasename > postgres_dump.tar