Re: CREATE DATABASE

Rafal Pietrak wrote:
> Hi All,
>
> I'd like to cast a small 'feature request' here for discussion/
> evaluation. The case is the following:
>
> When working on a new database application I quite frequently:
> -------------------------------
>     test_xx# \c template1
>     template1# DROP DATABASE test_xx;
>     template1# CREATE DATABASE test_xx TEMPLATE = earlier_version;
>     template1# \c test_xx
>     template1# \i some_cooked_dataset.sql-dump
> -------------------------------
>
> All this is of cource issued from psql utility, and using psql_history
> buffer.
>
> Now, the thing is, that I have to be very carefull and focused when
> going back in psql_history, as several times I've skiped the "\c
> test_xx" stage .... and ended up in a mass.

The quickest solution is to put the whole thing in one script and
execute that with \i or -f from the command-prompt.

--
   Richard Huxton
   Archonet Ltd