Jonathan Altman

I ran across this today while trying to use the chef community database cookbook.  If you want to use it along with a postgresql database to e.g. create databases and create and assign roles to users, then you may need to do the following, at least…

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…