Skip to content

Commit bebe5ac

Browse files
committed
Add how to get database/user listing information.
1 parent cfa72fa commit bebe5ac

File tree

2 files changed

+15
-11
lines changed

2 files changed

+15
-11
lines changed

doc/FAQ

Lines changed: 7 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: Wed Apr 17 22:48:04 EDT 2002
4+
Last updated: Thu Apr 18 00:44:51 EDT 2002
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

@@ -63,8 +63,8 @@
6363
4.5) What is the maximum size for a row, a table, and a database?
6464
4.6) How much database disk space is required to store data from a
6565
typical text file?
66-
4.7) How do I find out what tables or indexes are defined in the
67-
database?
66+
4.7) How do I find out what tables, indexes, databases, and users are
67+
defined?
6868
4.8) My queries are slow or don't make use of the indexes. Why?
6969
4.9) How do I see how the query optimizer is evaluating my query?
7070
4.10) What is an R-tree index?
@@ -697,10 +697,12 @@
697697
Indexes do not require as much overhead, but do contain the data that
698698
is being indexed, so they can be large also.
699699

700-
4.7) How do I find out what tables or indexes are defined in the database?
700+
4.7) How do I find out what tables, indexes, databases, and users are
701+
defined?
701702

702703
psql has a variety of backslash commands to show such information. Use
703-
\? to see them.
704+
\? to see them. There are also system tables beginning with pg_ that
705+
describe these too. Also, psql -l will list all databases.
704706

705707
Also try the file pgsql/src/tutorial/syscat.source. It illustrates
706708
many of the SELECTs needed to get information from the database system

doc/src/FAQ/FAQ.html

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@
1414
alink="#0000ff">
1515
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1616

17-
<P>Last updated: Wed Apr 17 22:48:04 EDT 2002</P>
17+
<P>Last updated: Thu Apr 18 00:44:51 EDT 2002</P>
1818

1919
<P>Current maintainer: Bruce Momjian (<A href=
2020
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
@@ -96,8 +96,8 @@ <H2 align="center">Operational Questions</H2>
9696
table, and a database?<BR>
9797
<A href="#4.6">4.6</A>) How much database disk space is required
9898
to store data from a typical text file?<BR>
99-
<A href="#4.7">4.7</A>) How do I find out what tables or indexes
100-
are defined in the database?<BR>
99+
<A href="#4.7">4.7</A>) How do I find out what tables, indexes,
100+
databases, and users are defined?<BR>
101101
<A href="#4.8">4.8</A>) My queries are slow or don't make use of
102102
the indexes. Why?<BR>
103103
<A href="#4.9">4.9</A>) How do I see how the query optimizer is
@@ -893,11 +893,13 @@ <H4><A name="4.6">4.6</A>) How much database disk space is required
893893
<P>Indexes do not require as much overhead, but do contain the data
894894
that is being indexed, so they can be large also.</P>
895895

896-
<H4><A name="4.7">4.7</A>) How do I find out what tables or indexes
897-
are defined in the database?</H4>
896+
<H4><A name="4.7">4.7</A>) How do I find out what tables, indexes,
897+
databases, and users are defined?</H4>
898898

899899
<P><I>psql</I> has a variety of backslash commands to show such
900-
information. Use \? to see them.</P>
900+
information. Use \? to see them. There are also system tables
901+
beginning with <i>pg_</i> that describe these too. Also, <i>psql
902+
-l</i> will list all databases.</P>
901903

902904
<P>Also try the file <I>pgsql/src/tutorial/syscat.source</I>. It
903905
illustrates many of the <SMALL>SELECT</SMALL>s needed to get

0 commit comments

Comments
 (0)