Re: SQL list table names - Mailing list pgsql-sql

From Alan Gutierrez
Subject Re: SQL list table names
Date
Msg-id avgrfn$rju$1@news.hub.org
Whole thread Raw
In response to SQL list table names  (alviN <gamboa@infophil.com>)
Responses Re: SQL list table names  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List 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
psqlusing \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



pgsql-sql by date:

Previous
From: Thomas O'Connell
Date:
Subject: Re: double precision to numeric overflow error
Next
From: Achilleus Mantzios
Date:
Subject: Re: SQL list table names