Difference between revisions of "Pg database"
Jump to navigation
Jump to search
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{lowercase}} | {{lowercase}} | ||
| − | *<code>pg_database</code> | + | * <code>pg_database</code> |
| + | |||
| + | [[SELECT datname FROM pg_database;]] | ||
| + | |||
| + | |||
| + | SELECT [[datname]] FROM pg_database WHERE datistemplate = false; | ||
| + | datname | ||
| + | ---------- | ||
| + | postgres | ||
| + | (1 row) | ||
== Related terms == | == Related terms == | ||
| − | * [[ | + | * [[Autovacuum]] |
| − | + | * <code>[[\l]]</code> | |
== See also == | == See also == | ||
* {{pg}} | * {{pg}} | ||
| + | * {{VACUUM}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
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:
