Retrieve Data Type

From: "Monica Robustelli" <monica_robustelli(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Retrieve Data Type
Date: 2003-10-28 15:13:19
Message-ID: Law10-F72Zdb5rSSruy000143e0@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear All,

I have updated the release of my Postgres Database, from 7.0 to 7.3.
>From the old version, I effected the following query to retrieve type and
length of a specific table field:

select *from pgadmin_tables where (table_name='".$strTableName."') AND
(column_name='".$strColumName."')

How I obtain the same result with the new Postgres release?

Thank's in advance!

Monica

_________________________________________________________________
Send instant messages to anyone on your contact list with MSN Messenger
6.0. Try it now FREE! http://msnmessenger-download.com

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2003-10-28 15:58:26 Re: another pg database corruption?
Previous Message pginfo 2003-10-28 15:07:18 Re: another pg database corruption?