Jonathan Altman

To list the schemas in a postgresql database:

select nspname from pg_namespace;

I wanted a nice convenient way to have multiple Rails apps share my single postgresql database but keep all the apps' tables/procs/views/other artifacts isolated from each other. I came up with the following solution, which I can't claim is…