Login:
$ psql <dbname> -U <user_name>
After login at Postgresql Console:
- Exit:
- dbname=# q
- List all tables:
- dbname=# dt
- Info about specific table
- dbname=# d+ <table_name>
List all rows where column value is null
- perspectivedb=# select * from cluster_config_property where key is null;
Deleting all rows where column value is null:
- perspectivedb=# delete from cluster_config_property where key is null;
Backing up a single table:
- This is done from regular prompt (not when you are logged into psql)
- $ pg_dump -t <table_name> <db_name> -U <user_name> > <target_file_name>.sql
Restoring a single table back into database: