On Fri, 2002-02-01 at 20:26, bangh wrote:
> There is a database template1 you can play with.
>
> If there is no table in template1, you can create one by:
>
> psql template1
> psql> create table mytable (
> psql> mydate datetime,
> psql> mymem text);
> psql> insert into mytable values('now', 'I am doing this today');
> psql> select * from mytable;
> psql>\q;If you do this, you will have mytable in every database you create thereafter. It is not called a template for no reason! template1 is copied in its entirety into every new database when it is created. (And so the rest of the advice is redundant, too.) A better choice is to run the regression tests and use the regression database for your experiments, since it will have a lot of tables already containing data. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "And be not conformed to this world; but be ye transformed by the renewing of your mind, that ye may prove what is that good, and acceptable, and perfect, will of God." Romans 12:2
signature.asc
Description: This is a digitally signed message part
