dba:postgresql:postgresql_basic_querys
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| dba:postgresql:postgresql_basic_querys [2023/10/23 07:25] – [Locks] dodger | dba:postgresql:postgresql_basic_querys [2024/03/15 09:16] – [list objects in schema] dodger | ||
|---|---|---|---|
| Line 235: | Line 235: | ||
| ===== list objects in schema ===== | ===== list objects in schema ===== | ||
| - | Change ''< | + | Change ''< |
| + | |||
| <code sql> | <code sql> | ||
| select n.nspname as schema_name, | select n.nspname as schema_name, | ||
| Line 639: | Line 641: | ||
| </ | </ | ||
| + | |||
| + | ===== dump/export all users with password ===== | ||
| + | <code bash> | ||
| + | pg_dumpall --globals-only --file=all_roles_and_users.sql -h 127.0.0.1 | ||
| + | </ | ||
| ===== List extensions installed ===== | ===== List extensions installed ===== | ||
dba/postgresql/postgresql_basic_querys.txt · Last modified: 2024/04/19 07:37 by dodger