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: (view raw, whole thread or download thread mbox)
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()".


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

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-2017 The PostgreSQL Global Development Group