> For the complete documentation index, see [llms.txt](https://book.ferro.pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://book.ferro.pro/db/pgsql.md).

# PostgreSQL

* [Info](/db/pgsql.md#info)
* [Config](/db/pgsql.md#config)
* [pgadmin](/db/pgsql.md#pgadmin)
* [Commands](/db/pgsql.md#commands)
* [user](/db/pgsql.md#user)
* [db](/db/pgsql.md#db)

## Info

```
SELECT version();
SELECT now();
```

## Config

<https://www.postgresql.org/docs/current/static/runtime-config-file-locations.html>

```
SHOW config_file;       -- /var/lib/postgresql/data/postgresql.conf
SHOW data_directory;    -- /var/lib/postgresql/data
SHOW hba_file;          -- /var/lib/postgresql/data/pg_hba.conf
    -- host-based authentication
    -- https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
SHOW ident_file;        -- /var/lib/postgresql/data/pg_ident.conf
    -- user name mapping: SYSTEM-USERNAME PG-USERNAME
SHOW external_pid_file;
```

## pgadmin

```
docker run -p 80:80 \
-e "PGADMIN_DEFAULT_EMAIL=user@domain.com" \
-e "PGADMIN_DEFAULT_PASSWORD=SuperSecret" \
-d dpage/pgadmin4
```

DB->'Schemas'->'public'->'Tables'->right click table->'View/Edit Data'->'All Rows'

## Commands

<https://www.postgresql.org/docs/current/static/app-psql.html>

## user

```
SELECT usename FROM pg_user;
CREATE USER fzinfz;
\password fzinfz
ALTER USER fzinfz WITH SUPERUSER;
\du
    -- list user/role
```

## db

```
CREATE database tutorial;
\c tutorial
psql -U postgres -h localhost -d tutorial
```