programatically obtaining table layout - Mailing list pgsql-admin

From Philip Rudling
Subject programatically obtaining table layout
Date
Msg-id 1030006940.22212.0@iris.uk.clara.net
Whole thread Raw
Responses Re: programatically obtaining table layout
List pgsql-admin
Is there a way of getting the output of a \d tablename  from within a
program (like describe in mysql)

Although this works fine from the postgres command line, from within a
program I get:

ODBC Error Code = 00000 ()

Error while executing the query (non-fatal); ERROR: parser: parse error at
or near "\"


SQL = "\d orders"

Data Source = "MESSINA"


The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (4:1) to (7:39) in the template file
/usr/local/apache/htdocs/stephen/messina/TESTER.cfm.



I am using coldfusion and unix ODBC driver.



SR




pgsql-admin by date:

Previous
From: Bhuvan A
Date:
Subject: Re: How can I Delete/Alter Unique Constraint
Next
From: "Jai"
Date:
Subject: timeout