[GENERAL] change owner to all object in a schema

Hi! I searched a lot on the net, but I haven't found a quick way to change owner to all objects in a schema. Could you please suggest me a tool or an existing script to do that ? Thank you, Nicola ---(end of broadcast)--- TIP 6: explain analyze is

[GENERAL] huge file in pg_xlog and base

Hi, I have 6 little dbs, but I see that my base directory needs 213MB and log are 114MB. Here my folder structure and size: 3571./base/1 3487./base/10792 4691./base/10793 3707./base/16384 16618 ./base/16386 0 ./base/64673/pgsql_tmp 143697 ./base/64673 0 ./base/86171/