> 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: Chris||Date: 2006-03-31 03:04:10|
|Subject: Re: PSQL Data Type: text vs. varchar(n)|
|Previous:||From: Joshua D. Drake||Date: 2006-03-30 21:33:48|
|Subject: Re: Performance Killer 'IN' ?|