Re: checking data type

raj wrote:
> Hi, Chris (great looking site, by the way)! thanks for responding. i
> was just practicing on postgres and encountered this problem. i am
> using pg admin for postgres and for some reason the commands you posted
> does not seem to work.  i was kinda looking for an built-in function
> like "upper() or max()".

http://www.postgresql.org/docs/8.1/interactive/information-schema.html

specifically

http://www.postgresql.org/docs/8.1/interactive/infoschema-columns.html

So you end up with:

SELECT * from information_schema.columns where
table_name='your_table_name' and column_name='your_column_name';

There is a lot of data there, but you should be able to find what you need.

--
Postgresql & php tutorials
http://www.designmagick.com/