checking data type

From: "raj" <royuco77(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: checking data type
Date: 2006-03-28 06:29:10
Message-ID: 1143527350.017140.203650@i39g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dick Kniep 2006-03-28 07:41:46 Schema's versus tablespace
Previous Message Alex Turner 2006-03-28 05:33:03 Re: [Bulk] General advice on database/web applications