|
14 | 14 | alink="#0000ff"> |
15 | 15 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
16 | 16 |
|
17 | | -<P>Last updated:Wed Apr17 22:48:04 EDT 2002</P> |
| 17 | +<P>Last updated:Thu Apr18 00:44:51 EDT 2002</P> |
18 | 18 |
|
19 | 19 | <P>Current maintainer: Bruce Momjian (<Ahref= |
20 | 20 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> |
@@ -96,8 +96,8 @@ <H2 align="center">Operational Questions</H2> |
96 | 96 | table, and a database?<BR> |
97 | 97 | <Ahref="#4.6">4.6</A>) How much database disk space is required |
98 | 98 | to store data from a typical text file?<BR> |
99 | | -<Ahref="#4.7">4.7</A>) How do I find out what tables orindexes |
100 | | -are defined in the database?<BR> |
| 99 | +<Ahref="#4.7">4.7</A>) How do I find out what tables,indexes, |
| 100 | +databases, and users are defined?<BR> |
101 | 101 | <Ahref="#4.8">4.8</A>) My queries are slow or don't make use of |
102 | 102 | the indexes. Why?<BR> |
103 | 103 | <Ahref="#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 |
893 | 893 | <P>Indexes do not require as much overhead, but do contain the data |
894 | 894 | that is being indexed, so they can be large also.</P> |
895 | 895 |
|
896 | | -<H4><Aname="4.7">4.7</A>) How do I find out what tables orindexes |
897 | | -are defined in the database?</H4> |
| 896 | +<H4><Aname="4.7">4.7</A>) How do I find out what tables,indexes, |
| 897 | +databases, and users are defined?</H4> |
898 | 898 |
|
899 | 899 | <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> |
901 | 903 |
|
902 | 904 | <P>Also try the file<I>pgsql/src/tutorial/syscat.source</I>. It |
903 | 905 | illustrates many of the<SMALL>SELECT</SMALL>s needed to get |
|