1. List all the schema in the database
   \dt *.*
\dt schema.*
2. List of Sequences
   \ds *.*
3. Run a sql file
   psql -f filename.sql -U user
4. Grants and revokes

--ACCESS DB
REVOKE CONNECT ON DATABASE nova FROM PUBLIC;
GRANT  CONNECT ON DATABASE nova  TO user;

--ACCESS SCHEMA
REVOKE ALL     ON SCHEMA public FROM PUBLIC;
GRANT  USAGE   ON SCHEMA public  TO user;

--ACCESS TABLES
REVOKE ALL ON ALL TABLES IN SCHEMA public FROM PUBLIC ;
GRANT SELECT                         ON ALL TABLES IN SCHEMA public TO read_only ;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO read_write ;
GRANT ALL                            ON ALL TABLES IN SCHEMA public TO admin ;

Reference

• http://www.linuxinsight.com/optimize_postgresql_database_size.html Tidbits on optimizing postgres database.
• https://help.ubuntu.com/community/PostgreSQL Postgres Introduction on install and setup
• https://medium.com/engineering-on-the-incline/securing-postgresql-databases-in-a-multi-user-environment-4b992dc785fb – User Role – setup.
•  https://www.azureblue.io/how-to-manage-psql-db-permissions-with-aad-groups/