Skip site navigation (1) Skip section navigation (2)

Re: checking data type

From: Chris <dmagick(at)gmail(dot)com>
To: raj <royuco77(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: checking data type
Date: 2006-03-31 02:59:01
Message-ID: 442C9AF5.9090803@gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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/

In response to

pgsql-general by date

Next:From: ChrisDate: 2006-03-31 03:04:10
Subject: Re: PSQL Data Type: text vs. varchar(n)
Previous:From: Joshua D. DrakeDate: 2006-03-30 21:33:48
Subject: Re: Performance Killer 'IN' ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group