Differences

This shows you the differences between two versions of the page.

--- tips:db:postgres [2017/11/22 08:58] – [Basic operations] scipio
+++ tips:db:postgres [2019/03/13 09:55] (current) – [Basic operations] scipio
@@ Line 20: / Line 20: @@
 ===== Basic operations =====
+<code>
+# list databases
+\l
+# connect to database
+\c giano
+# list schema
+\dn
+# list tables in schema
+\dt auth.*
+# describe table
+\d+ auth.users
+# list of installed extensions
+\dx
+# enable expanded display
+\x
+</code>
+set search path for database
+<code>
+psql <database>
+ALTER DATABASE database_name SET search_path TO schema_name,public;
+</code>
 drop role gianoauth
@@ Line 53: / Line 83: @@
 ALTER USER gianoauth SET search_path TO auth;
 ALTER ROLE gianoauth IN DATABASE giano SET search_path TO auth;
+</code>
+create superuser <admin> with password
+<code>
+createuser -P -s -e admin
+</code>
+create user and database for sentry
+<code>
+CREATE ROLE sentry WITH PASSWORD 'blabla' LOGIN;
+CREATE DATABASE sentry ENCODING 'UTF8' OWNER sentry;
 </code>
 ==== developer containers =====
@@ Line 82: / Line 124: @@
 apt install wget python3-pip
 pip3 install -U pip
-cd /tmp
+pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.2/pip/pgadmin4-4.2-py2.py3-none-any.whl
-wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.0/pip/pgadmin4-2.0-py2.py3-none-any.whl
-pip install ./pgadmin4-2.0-py2.py3-none-any.whl
 # define ip binding
@@ Line 123: / Line 163: @@
 <code>
-PG_VERSION=0.9.1-alpha
+PG_VERSION=0.9.1-beta1
 # for building, can remove after install
-sudo apt install make g++ qt5-qmake libxml2-dev libpq-dev pkg-config libqt5svg5-dev
+sudo apt install -y make g++ qt5-qmake libxml2-dev libpq-dev pkg-config libqt5svg5-dev
 # runtime dependencies
-sudo apt install qt5-default libqt5svg5 postgresql-server-dev-all
+sudo apt install -y qt5-default libqt5svg5 postgresql-server-dev-all
 cd /usr/local/src
-sudo apt install wget
+sudo apt install -y wget
 wget https://github.com/pgmodeler/pgmodeler/archive/v${PG_VERSION}.tar.gz
 tar xvzf v${PG_VERSION}.tar.gz
-cd pgmodeler-0.9.1-alpha/
+cd pgmodeler-${PG_VERSION}/
 qmake pgmodeler.pro
 make -j 4