PostgreSQL commands to Remember

Inserting Query
psql -U postgresqluser databasename -f file

Backup the PostgreSQL database
pg_dump databasename > databasebackup.bak