> Hi,
>
> I made some changes to postgresql.conf and I want them to take effect
without
> having to restart the server.
>
> I tried
>
> select pg_reload_conf();
> /usr/pgsql-9.1/bin/pg_ctl reload
>
> but when I do 'show all', I see no changes take effect.
>
> There settings I tried to change are:
>
If you are looking for list of empty schema's (No objects in schema), then
you can use below query:
select nspname from pg_namespace where oid not in (select relnamespace from
pg_class) and oid not in (select oid from pg_proc);
Regards,
Baji Shaik.
On Thu, Nov 15, 2012 at 6:13 PM, Achilleas Man