Re: list of tables ? -update to question ...

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Steve Brett <SBrett(at)e-mis(dot)com>
Cc: Stephane Schildknecht <sschildknecht(at)aurora-linux(dot)com>, "Pgsql-Sql (E-mail)" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: list of tables ? -update to question ...
Date: 2002-07-11 18:38:40
Message-ID: 3D2DD0B0.3EE1E369@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Steve Brett wrote:
>
> sorry ... i didn't make myself clear ...
>
> i have of course come across \dt before ...
>
> what i meant was via sql as in 'select tablelist from <some pg sys table
> perhaps ?>'

What about:

SELECT * FROM pg_tables;

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Manfred Koizar 2002-07-11 18:44:58 Re: [HACKERS] please help on query
Previous Message Andy Kopciuch 2002-07-11 18:09:52 Re: please help on query