Re: [GENERAL] How to use database?

2008-03-27 Thread Anton Andreev
Hi, Thank you for you detailed answer, but I am exactly in the case when I want to paste the script and hit F5 and have both the database and tables created. A problem also comes from the fact that in order to use the query window in pgadmin3, you need to select a database. Then when you

Re: [GENERAL] How to use database?

2008-03-26 Thread Shane Ambler
Anton Andreev wrote: Hi, Thank you for you detailed answer, but I am exactly in the case when I want to paste the script and hit F5 and have both the database and tables created. A problem also comes from the fact that in order to use the query window in pgadmin3, you need to select a

[GENERAL] How to use database?

2008-03-25 Thread Anton Andreev
Hi, How to use a database I have just created in a script that I am executing in Pgadmin3 on Windows? I can not use USE Northwind; or \connect Northwind;? Cheers, Anton -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] How to use database?

2008-03-25 Thread Andrej Ricnik-Bay
On 25/03/2008, Anton Andreev [EMAIL PROTECTED] wrote: Hi, Hi, How to use a database I have just created in a script that I am executing in Pgadmin3 on Windows? I can not use USE Northwind; or \connect Northwind;? Hard to say w/o knowing the script. Does it just create tables, or does it

Re: [GENERAL] How to use database?

2008-03-25 Thread Shane Ambler
Anton Andreev wrote: Hi, How to use a database I have just created in a script that I am executing in Pgadmin3 on Windows? If you are in pgAdmin then you don't need the connect command. When you select the db from the side list it connects you and lists the contents of the db. From the