dba:postgresql:postgresql_basic_querys
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
dba:postgresql:postgresql_basic_querys [2023/10/23 07:24] – [Locks] dodger | dba:postgresql:postgresql_basic_querys [2024/03/15 09:18] – [show object source] 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 412: | Line 414: | ||
===== show object source ===== | ===== show object source ===== | ||
Change '' | Change '' | ||
+ | |||
+ | |||
<code sql> | <code sql> | ||
select prosrc from pg_proc where proname=' | select prosrc from pg_proc where proname=' | ||
Line 604: | Line 608: | ||
</ | </ | ||
- | This query will list all //blocking sessions//: | + | This query will list all //blocking sessions//, see [[https:// |
<code sql> | <code sql> | ||
SET application_name=' | SET application_name=' | ||
Line 639: | Line 643: | ||
</ | </ | ||
+ | |||
+ | ===== 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