Re: SQL list table names

From: Alan Gutierrez <ajglist(at)izzy(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL list table names
Date: 2003-01-08 09:34:17
Message-ID: avgrfn$rju$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

alviN wrote:
> is it possible to execute an sql query to be able to list the tables's
> names? well, you can do it on psql using \dt. but im talking about the SQL
> statement, because i want to execute that query from a script.

Oh, even *I* know the answer to this one! Run psql with the -E argument to see
the SQL used to run \dt. Look at man psql for for info for just:

psql -E template1

Alan Gutierrez

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Achilleus Mantzios 2003-01-08 13:59:53 Re: SQL list table names
Previous Message Brian Johnson 2003-01-08 04:52:33 Re: Lost - one sequence

Browse pgsql-sql by date

  From Date Subject
Next Message Tambet Matiisen 2003-01-08 11:14:24 full join in view
Previous Message Thomas O'Connell 2003-01-08 05:36:12 Re: double precision to numeric overflow error