Start the Docker
docker run --rm   --name pg-docker 
-e POSTGRES_PASSWORD=docker 
-d -p 5432:5432 
-v $HOME/docker/volumes/postgres:/var/lib/postgresql/data  postgres
List Database
SELECT datname FROM pg_database
WHERE datistemplate = false;
List Schema
SELECT schema_name FROM information_schema.schemata;
List Tables
SELECT * FROM pg_catalog.pg_tables
List tables schema
SELECT column_name, data_type, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '';
Initial Source : Git Link source