SEO

#1 (**permalink**) 04-09-2008, 08:59 AM

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.

#2 (**permalink**) 04-09-2008, 09:02 AM

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/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#3 (**permalink**) 04-09-2008, 09:02 AM

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()".

#4 (**permalink**) 04-09-2008, 09:03 AM

raj wrote:
> 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()".

http://www.postgresql.org/docs/8.1/i...on-schema.html

specifically

http://www.postgresql.org/docs/8.1/i...a-columns.html

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
http://www.designmagick.com/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

checking data type