Cacher is the code snippet organizer for pro developers

Dump

Backup:

$ pg_dump -U {user-name} {source_db} -f {dumpfilename.sql}

Restore:

$ psql -U {user-name} -d {desintation_db}-f {dumpfilename.sql}

Connect: $ psql -U {user-name} {source_db}

After connect

List databases:

\l

List tables:

\dt \dt+

Desc table:

\d+ tablename