Re: checking data type

raj wrote:
> is there a function that could check for a variable's data type?  like
> i want to check all the columns of a table and if i found a column with
> an integer  data type i set it to a default 1 and i'll set a constant
> to a column of type text.

You could start psql with -E:

psql -d dbname -E

run \d <tablename>

and use the queries that postgres runs to work it out..

There could be a simpler way though in the system catalogues (anyone?).


I should ask why you need this info ;)

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