Category: PostgreSQL

postgresql service local https://hub.docker.com/_/postgres docker run –name postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres docker exec -it postgres /bin/bash test connection pg_isready -d -h -p -U pg_isready -h 127.0.0.1 -p 5432 -U root apt install postgresql-client-13 find configuration file psql -U postgres -c ‘SHOW config_file’ print time psql -U postgres -c “select (to_char(CURRENT_TIMESTAMP ,’yyyy-MM-dd HH24:MI’)||’:00′)::timestamp”