Start the containers: docker-compose up -d
Rebuild and start: docker-compose up -d --build
Login: docker exec -it postgres psql -U user
This command will be determined by the docker-compose.yml file if different env variables are used.
Eg. docker exec -it postgres psql -U user testdb as this takes a database name.
Show tables: \dt
Show databases: \l
CREATE TABLE COMPANY (ID INT PRIMARY KEY NOT NULL, NAME text);
INSERT INTO company(id,name) values (1,'test');
SELECT * from company;