DB/Postgres PostgreSQL
Jump to navigation
Jump to search
- 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)