列出数据库 [英] Listing databases

问题描述

很抱歉新手问题，但是如何让PostgreSQL列出可用的数据库？
？我知道如何登录某个数据库，但

并未列出所有数据库。我知道这一定是可能的，因为

phppgAdmin网站用他们的试用服务器演示了它。


谢谢，

Doug Hall

---------------------------（广播结束）---------- -----------------

提示2：您可以使用取消注册命令一次性取消所有列表

（发送取消注册YourEmailAddressHere以 ma*******@postgresql.org ）

Sorry for the newbie question, but how do you get PostgreSQL to list
the available databases? I know how to log into a certain database, but
not list all of them. I know this must be possible because the
phppgAdmin web site demonstrates it with their trial server.

Thanks,
Doug Hall
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

推荐答案

Doug Hall写道：

Doug Hall wrote:

对不起新手问题，但是如何让PostgreSQL列出
可用数据库？我知道如何登录某个数据库，但不会列出所有这些数据库。我知道这一定是可能的，因为phppgAdmin
网站用他们的试用服务器演示了它。


select * from pg_database;


谢谢，
Doug Hall

---------------------------（播出结束） - --------------------------
提示2：您可以使用取消注册命令立即取消所有列表
（发送取消注册YourEmailAddressHere到 ma*******@postgresql.org ）

Sorry for the newbie question, but how do you get PostgreSQL to list the
available databases? I know how to log into a certain database, but not
list all of them. I know this must be possible because the phppgAdmin
web site demonstrates it with their trial server.

select * from pg_database;

Thanks,
Doug Hall
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

< br $>
-

命令提示，Inc。，Mammoth PostgreSQL的主页 - S / ODBC和S / JDBC

Postgresql支持，编程共享主机和专用托管。

+ 1-503-667-4564 - [e-mail] - http://www.commandprompt.com

Mammoth PostgreSQL Replicator。 PostgreSQL的集成复制

---------------------------（广播结束）------ ---------------------

提示5：您查看了我们广泛的常见问题解答吗？

http://www.postgresql.org/docs/faqs/FAQ.html

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
[phone] - [e-mail] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Doug Hall写道：

Doug Hall wrote:

抱歉新手问题，但是如何让PostgreSQL列出
可用的数据库？我知道如何登录某个数据库，但不会列出所有这些数据库。我知道这一定是可能的，因为phppgAdmin
网站用他们的试用服务器演示了它。


select * from pg_database;


谢谢，
Doug Hall

---------------------------（播出结束） - --------------------------
提示2：您可以使用取消注册命令立即取消所有列表
（发送取消注册YourEmailAddressHere到 ma*******@postgresql.org ）

Sorry for the newbie question, but how do you get PostgreSQL to list the
available databases? I know how to log into a certain database, but not
list all of them. I know this must be possible because the phppgAdmin
web site demonstrates it with their trial server.

select * from pg_database;

Thanks,
Doug Hall
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

< br $>
-

命令提示，Inc。，Mammoth PostgreSQL的主页 - S / ODBC和S / JDBC

Postgresql支持，编程共享主机和专用托管。

+ 1-503-667-4564 - [e-mail] - http://www.commandprompt.com

Mammoth PostgreSQL Replicator。 PostgreSQL的集成复制

---------------------------（广播结束）------ ---------------------

提示5：您查看了我们广泛的常见问题解答吗？

http://www.postgresql.org/docs/faqs/FAQ.html

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
[phone] - [e-mail] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

>很抱歉新手问题，但是如何让PostgreSQL列出

> Sorry for the newbie question, but how do you get PostgreSQL to list

可用的数据库？我知道如何登录某个数据库，但不列出所有数据库。我知道这一定是可能的，因为
phppgAdmin网站用他们的试用服务器演示了它。

the available databases? I know how to log into a certain database, but
not list all of them. I know this must be possible because the
phppgAdmin web site demonstrates it with their trial server.

在psql中使用\l命令。

-

Mike Nolan

------------------------- - （广播结束）---------------------------

提示9：规划人员会忽略你的如果您的

加入列的数据类型不匹配，则希望选择索引扫描

Use the \l command within psql.
--
Mike Nolan
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match

这篇关于列出数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！