DB/Postgres PostgreSQL

• Managing PostgreSQL users and roles 04 MAR 2019, AWS Blog

Cli client

# Install
apt-get install -yq postgresql-client

# Connect
export POSTGRES_DB=postgres
export POSTGRES_USER=postgres
export POSTGRES_PASSWORD=mypassword

psql -h localhost -p 5432 -U postgres postgres
psql (12.3 (Debian 12.3-1.pgdg100+1))
Type "help" for help.

postgres=#
  \l  -- list all databases
  \dt -- list all the tables in the current database
  \c mydatabase   -- switch database
  \d <table_name> -- describe a table
  \g -- execute previous command
  \? -- help
  \h DROP TABLE -- help about particular comamnd
  \timing -- execution times of queries

# Show version
postgres=# SELECT version();
                                                     version                                                      
------------------------------------------------------------------------------------------------------------------
 PostgreSQL 12.3 (Debian 12.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
(1 row)

Operational queries

-- Reset user password, no need to flush or log out
ALTER USER user_name WITH PASSWORD 'new_password';