On September 14, 2014 5:01:54 PM EDT, cowwoc <cowwoc(at)bbs(dot)darktech(dot)org> wrote:
>Hi,
>
>I'd like to propose the ability to create temporary schemas.
>
>This would facilitate running unit tests, where developers would like
>to run
>the same creation script for unit tests and production code but do not
What if you ran a temporary database instead? You can use some combination of PGHOST, PGPORT, PGUSER and PGDATABASE to "pg_ctl start" an empty DB and then point your unit tests at it. Then you aren't in danger of wiping out your production DB either.