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 "upp
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:
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
