Retrieve Data Type - Mailing list pgsql-admin

From Monica Robustelli
Subject Retrieve Data Type
Date
Msg-id Law10-F72Zdb5rSSruy000143e0@hotmail.com
Whole thread Raw
List 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


pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: another pg database corruption?
Next
From: pginfo
Date:
Subject: Re: another pg database corruption?