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/11/26 16:10] – [pgadmin] 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 | ||
| Line 85: | 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 114: | 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:// | + | |
| - | wget https:// | + | |
| - | pip install ./ | + | |
| # define ip binding | # define ip binding | ||
tips/db/postgres.1543245043.txt.gz · Last modified: by scipio
