Yanor.net/
Wiki
Blog
GitHub
Sandbox
開始行:
* データベースの一覧を確認 [#vd4b21f8]
*** シェルから [#tf0afbfb]
$ psql -l
$ psql --list
List of databases
Name | Owner | Encoding | Collate | Ctyp...
-----------+----------+----------+-------------+--------...
kurz_prod | pgadmin | UTF8 | en_US.UTF-8 | en_US.U...
pgadmin | pgadmin | UTF8 | en_US.UTF-8 | en_US.U...
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.U...
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
(5 rows)
*** psqlから [#p6353c94]
=> \l
=>\list
...
Name | Owner | Encoding | Collate | Ctype ...
------------+----------+----------+-------------+-------...
pgbench | postgres | UTF8 | en_US.UTF-8 | en_US.U...
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.U...
slonmaster | postgres | UTF8 | en_US.UTF-8 | en_US.U...
slonslave | postgres | UTF8 | en_US.UTF-8 | en_US.U...
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
test | postgres | UTF8 | en_US.UTF-8 | en_US.U...
(7 rows)
*** SQLで [#r5a824dd]
SELECT datname FROM pg_database WHERE datistemplate = fa...
** 参考 [#h0f39943]
https://dba.stackexchange.com/questions/1285/how-do-i-lis...
終了行:
* データベースの一覧を確認 [#vd4b21f8]
*** シェルから [#tf0afbfb]
$ psql -l
$ psql --list
List of databases
Name | Owner | Encoding | Collate | Ctyp...
-----------+----------+----------+-------------+--------...
kurz_prod | pgadmin | UTF8 | en_US.UTF-8 | en_US.U...
pgadmin | pgadmin | UTF8 | en_US.UTF-8 | en_US.U...
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.U...
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
(5 rows)
*** psqlから [#p6353c94]
=> \l
=>\list
...
Name | Owner | Encoding | Collate | Ctype ...
------------+----------+----------+-------------+-------...
pgbench | postgres | UTF8 | en_US.UTF-8 | en_US.U...
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.U...
slonmaster | postgres | UTF8 | en_US.UTF-8 | en_US.U...
slonslave | postgres | UTF8 | en_US.UTF-8 | en_US.U...
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.U...
| | | | ...
test | postgres | UTF8 | en_US.UTF-8 | en_US.U...
(7 rows)
*** SQLで [#r5a824dd]
SELECT datname FROM pg_database WHERE datistemplate = fa...
** 参考 [#h0f39943]
https://dba.stackexchange.com/questions/1285/how-do-i-lis...
ページ名: