Difference between revisions of "Pg database"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
* <code>pg_database</code> | * <code>pg_database</code> | ||
| − | SELECT datname FROM [[ | + | [[SELECT datname FROM pg_database;]] |
| + | |||
| + | |||
| + | SELECT [[datname]] FROM pg_database WHERE datistemplate = false; | ||
| + | datname | ||
| + | ---------- | ||
| + | postgres | ||
| + | (1 row) | ||
== Related terms == | == Related terms == | ||
* [[Autovacuum]] | * [[Autovacuum]] | ||
| + | * <code>[[\l]]</code> | ||
== See also == | == See also == | ||
Latest revision as of 14:20, 27 September 2024
pg_database
SELECT datname FROM pg_database;
SELECT datname FROM pg_database WHERE datistemplate = false; datname ---------- postgres (1 row)
Related terms[edit]
See also[edit]
Advertising:
