Обсуждение: checking data type
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.
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/
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()".
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/interactive/information-schema.html specifically http://www.postgresql.org/docs/8.1/interactive/infoschema-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/