Re: Feature request: temporary schemas

On September 14, 2014 5:01:54 PM EDT, cowwoc  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.