On Tue, Nov 25, 2008 at 8:23 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Dave Page" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers