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/
