mercredi 26 décembre 2018
Docker PostgreSQL
Par Arnaud Charlier, mercredi 26 décembre 2018 à 23:02 :: Linux et Debian
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 postgresList 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_tablesList tables schema
SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'Initial Source : Git Link source';