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
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.
thanks.
alviN
---(end of broadcast)---
