[GENERAL] list databases with SQL command

Hi, maybe its a silly question, but is there a way to list all databases with an SQL command? I know about the \l command from psql, but i wonder if such things are possible with SQL. regards, David ---(end of broadcast)--- TIP 9: the planner will

[GENERAL] changing column from int4 to int8, what happens with indexes?

Hi, well, i think the answer is simple 'it works' but i am not sure. When i change the column type from int4 to int8, are the indexes still usable or do i have to drop the indexes and create them again? regards, David ---(end of broadcast)--- TIP 9

Re: [GENERAL] OS X Install

I think the user is there in 10.3 by default. Apple is using PostgreSQL in one of their products. In order to use postgres (and to have postgres show up as a normal user available in the login menu) I deleted the user in NetInfo Manager. You also have to delete the postgres group. After doing t

[GENERAL] list of open connections / terminate a connection?

Hi, is it possible (i am pretty sure) to list the open connections clients have to a particular database and to force close the connection? regards David ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] RTRIM always used with JDBC?

Hi Kris, i am using Postgres 7.4.2 with jdbc. Every time i try to select a varchar the SQL generated by the jdbc driver uses RTRIM(t0.columnname) which breaks an existing application. Is this normal, can we disable the RTRIM usage? I assume from this bold claim that you have written an SQL query l

[GENERAL] RTRIM always used with JDBC?

Hi, i am using Postgres 7.4.2 with jdbc. Every time i try to select a varchar the SQL generated by the jdbc driver uses RTRIM(t0.columnname) which breaks an existing application. Is this normal, can we disable the RTRIM usage? regards David ---(end of broadcast)-