Re: How to "use" database?

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 create a new
database you can not access it by name cause you receive an error "cross
database referencing is not allowed".

Cheers,
Anton

Shane Ambler wrote:
> 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 query window in pgAdmin (where you can enter any sql
> statements) which is where I think you are opening your script file,
> it will have a popup menu that you can choose the db to run the
> commands on (or the sql script you are opening).
>
>> I can not use "USE Northwind;" or "\connect Northwind;"?
>
> I believe you get the USE command from MS SQL Server examples -
> postgres doesn't have that command.
>
> The \connect is a 'shell' command used in psql - the cli based
> postgres client that comes with postgresql. This would not be
> recognised in the pgAdmin query window, which would only accept valid
> SQL statements.
>
>
> I am thinking that if you are writing a script that creates a db then
> wants to connect to it and create tables etc, you should look at
> sending it to psql.
>
> From a dos prompt you can use something like -
> psql -U postgres -W -f myscript.sql
>
>
> If you start psql then you can use the psql command \i myscript.sql to
> run the script.
>
> You may need to add full pathnames in these examples.
>
>
>