On Tue, Nov 25, 2008 at 8:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Dave Page" <dpage@pgadmin.org> writes:
>> I'm in favour of including it by default (at initdb), so it's there
>> for new users to play with on any fresh install - however, there is
>> only a point to that if all the documentation examples are based on
>> that database to allow copy-paste-play.
>
> You would also have to assume that all the examples are non-destructive,
> and that no one ever extends an example in a destructive way. This
> seems like a non-starter. Better to provide the sample database in a
> form in which it can be easily dropped/reloaded. I'm envisioning that
> there's a source file in $sharedir and we tell people
>
> createdb example
> psql -f $sharedir/example.sql example
There's good precedent for that...SQL Server for example does something similar:
http://msdn.microsoft.com/en-us/library/aa276825(SQL.80).aspx
It's a good learning tool and would really raise the value of the documentation.
merlin