programatically obtaining table layout

From: "Philip Rudling" <psr(at)clara(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: programatically obtaining table layout
Date: 2002-08-22 09:00:46
Message-ID: 1030006940.22212.0@iris.uk.clara.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jai 2002-08-22 09:58:38 timeout
Previous Message Oliver Elphick 2002-08-22 06:10:27 Re: [ADMIN] How to execute my trigger when update certain columns