From: | "Mike D'Agosta" <mdagosta(at)earthtribe(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Is there anything like DESCRIBE? |
Date: | 2001-01-25 20:56:17 |
Message-ID: | 94q48i$5me$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I got a response in email, so I assume the author wants to remain anonymous.
He wrote:
>There's an option to psql (I think -E or -e) that will make it echo all
>the SQL queries it does when you do something like "\d table"
So running a "psql -E <dbname>" and then doing a "\d <table>" will give you
information similar to what you would normally get from a DESCRIBE.
Mike
----------------------------------------------------------------------------
--------------------------
"Mike D'Agosta" <mdagosta(at)earthtribe(dot)net> wrote in message
news:94n93j$2j6j$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> Hi,
>
> I have a number of empty tables and I want to get the column names and
> data types with an SQL statement. I want to do this procedurally, not
> interactively (so I can't use \d <tablename> in psql). Postgres doesn't
> support DESCRIBE... is there any other way to do this?
>
> Thanks!
> Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Davis | 2001-01-25 20:57:08 | RE: Is there anything like DESCRIBE? |
Previous Message | Stephan Szabo | 2001-01-25 20:43:24 | Re: Don't want blank data |