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 08:47] – [Basic operations] scipio | tips:db:postgres [2019/03/13 09:55] (current) – [Basic operations] scipio | ||
|---|---|---|---|
| Line 34: | Line 34: | ||
| \dt auth.* | \dt auth.* | ||
| + | # describe table | ||
| + | \d+ auth.users | ||
| + | |||
| + | # list of installed extensions | ||
| + | \dx | ||
| + | |||
| + | # enable expanded display | ||
| + | \x | ||
| + | </ | ||
| + | |||
| + | set search path for database | ||
| + | < | ||
| + | psql < | ||
| + | ALTER DATABASE database_name SET search_path TO schema_name, | ||
| </ | </ | ||
| Line 74: | 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 103: | 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.1539240452.txt.gz · Last modified: by scipio
