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/