On Thu, Apr 21, 2005 at 11:33:07PM -0400, [EMAIL PROTECTED] wrote:
>
> My question is, what command can I issue to list all the tables in a
> database?
If you're using psql then you can use the \dt command, although that
will show only the tables in your search path (which is probably what
you
> How would I list all tables in a database?
You can list all tables with:
select * from pg_class;
but that will give you system tables also.
I think that if you use the \z command in psql, it will give you a list
of all tables in the current database.
Matt
