tips:db:postgres
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| tips:db:postgres [2018/10/11 14:29] – [Basic operations] scipio | tips:db:postgres [2019/03/13 09:55] (current) – [Basic operations] scipio | ||
|---|---|---|---|
| Line 33: | Line 33: | ||
| # list tables in schema | # list tables in schema | ||
| \dt auth.* | \dt auth.* | ||
| + | |||
| + | # describe table | ||
| + | \d+ auth.users | ||
| # list of installed extensions | # list of installed extensions | ||
| \dx | \dx | ||
| + | |||
| + | # enable expanded display | ||
| + | \x | ||
| </ | </ | ||
| Line 41: | Line 47: | ||
| < | < | ||
| psql < | psql < | ||
| - | ALTER DATABASE database_name SET search_path TO schema_name, | + | ALTER DATABASE database_name SET search_path TO schema_name, |
| </ | </ | ||
| Line 82: | Line 88: | ||
| < | < | ||
| createuser -P -s -e admin | createuser -P -s -e admin | ||
| + | </ | ||
| + | |||
| + | |||
| + | create user and database for sentry | ||
| + | < | ||
| + | CREATE ROLE sentry WITH PASSWORD ' | ||
| + | CREATE DATABASE sentry ENCODING ' | ||
| </ | </ | ||
| ==== developer containers ===== | ==== developer containers ===== | ||
| Line 111: | Line 124: | ||
| apt install wget python3-pip | apt install wget python3-pip | ||
| pip3 install -U pip | pip3 install -U pip | ||
| - | cd /tmp | + | pip install |
| - | wget https:// | + | |
| - | pip install ./pgadmin4-2.0-py2.py3-none-any.whl | + | |
| # define ip binding | # define ip binding | ||
tips/db/postgres.1539260968.txt.gz · Last modified: by scipio
