如何列出哪些表可用？ [英] How to list which tables are available?

问题描述

看起来很简单，但我如何获得数据库中可用的表格的列表

。我找不到一个SQL命令，但是

必须是一种方式！


谢谢。


Bertwim

解决方案

2003年10月14日星期二10:53，BWH van Beest写道：

它似乎是如此基本，但我如何获得数据库中可用的表格列表。我找不到一个SQL命令，但是
必须是一种方式！

在psql中使用\d或\dt


如果用-E标志启动psql，它会告诉你它是如何做的。


还有一些pg_xxx视图显示这种事情

（pg_tables，pg_indexes等）。我认为这些都包含在

手册的附录中。

-

Richard Huxton

Archonet Ltd


---------------------------（播出结束）------ ---------------------

提示1：订阅和取消订阅命令转到 ma ******* @ postgresql.org

星期二，2003-10 -14 at 04:53，BWH van Beest写道：

它似乎是如此基本，但我如何获得数据库中可用的表格列表。我找不到一个SQL命令，但是
必须是一种方式！

"

< blockquote> man psql"，然后搜索字符串"所有表的列表"

It seems so elementary, but how I get a list of which tables are
available in a database. I can''t find an SQL command for this, but there
must be a way!

Thanks.

Bertwim

解决方案

On Tuesday 14 October 2003 10:53, B.W.H. van Beest wrote:

It seems so elementary, but how I get a list of which tables are
available in a database. I can''t find an SQL command for this, but there
must be a way!

In psql use \d or \dt

If you start psql with the -E flag it will show you how it does that.

There are also a number of pg_xxx views that show this sort of thing
(pg_tables, pg_indexes etc). I think these are covered in an appendix of the
manuals.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

On Tue, 2003-10-14 at 04:53, B.W.H. van Beest wrote:

It seems so elementary, but how I get a list of which tables are
available in a database. I can''t find an SQL command for this, but there
must be a way!

"

man psql", then search for the string "list of all tables"

这篇关于如何列出哪些表可用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！