[SQL] Altering pg_conndefaults

how do i alter values of pg_conndefaults? example user=user1 to user=user2 thanks in advance ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that yo

[SQL] Altering pg_conndefaults

how do i change the User in pg_conndefaults because the user is not valid to connect to DB. one thing i can do is to add the User but is there a way to change the user seen in pg_conndeafaults... thanks in advance

[SQL] Arithmetic operation on DATE

is it possible to add a date datatype column to a number resulting to a date.. theoretically it should do this,,, X is in months date + X = date --> 2001-08-20 + 6 = 2002-02-20 -- The information contained in this messa

[SQL] Arithmetic operation on DATE

is it possible to add a date datatype column to a number resulting to a date.. theoretically it should do this,,, X is in months date + X = date --> 2001-08-20 + 6 = 2002-02-20 -- The information contained in this

[SQL] AUTOINCREMENT--help

Is there a function in SQL that does autoincrementing... eg. CREATE TABLE (name varchar(40),num_id int); wherein num_id starts with 0 and then when ever I INSERT another record num_id goes 1 etc Thanks in advance