Re: sql statement to give functionality of \d tablename?

From: Lee Harr <missive(at)frontiernet(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: sql statement to give functionality of \d tablename?
Date: 2002-08-22 23:14:53
Message-ID: ak3r9d$2avn$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In article <1030007114(dot)22469(dot)0(at)iris(dot)uk(dot)clara(dot)net>, Philip Rudling wrote:
> Is the an SQL statement that can be used from within a program that will
> give the output of \d command? Like the describe command in MySQL's version
> of SQL?
>

There is a flag to psql which will show you the sql from the
backslash commands. I believe it is -E, but check the manpage.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Yon Den Baguse Ngarso 2002-08-23 03:39:52 SELECT ... WHERE ... NOT IN (SELECT ...);
Previous Message imtiaz sm 2002-08-22 16:26:57 Re: BITMAP INDEXES...