Обсуждение: \d command

Jodi Kanter wrote:

> Can anyone tell me the sql that is being sent to the database when
> typeing this command? I am working on writing some code that will show a
> list of columns in a table. Is there a describe statement?
>
> Thanks
>
> Jodi Kanter


Start up psql with the -E switch. It will then show you all the internal
sql statements that it uses.

HTH,

Joe

On Tue, 22 Jan 2002, Jodi Kanter wrote:

> Can anyone tell me the sql that is being sent to the database when
> typeing this command? I am working on writing some code that will show
> a list of columns in a table. Is there a describe statement?

start psql with the -E option and it'll show you the queries used.