On Wed, 8 Jan 2003, Alan Gutierrez wrote:
> 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*
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 argume
If you start psql like so
psql -E
Then all the SQL behind the \d type commands is displayed for you.
adam
> 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 exec
