Re: How to run a script with Query Tool? - Mailing list pgsql-novice

From David G. Johnston
Subject Re: How to run a script with Query Tool?
Date
Msg-id CAKFQuwa8nEGfhyPwktFHYE4OFE7ffGFD_EQEMZGwk+4=2pWf2Q@mail.gmail.com
Whole thread Raw
In response to How to run a script with Query Tool?  (Richard Bernstein <richb201@gmail.com>)
List pgsql-novice
On Friday, June 19, 2020, Richard Bernstein <richb201@gmail.com> wrote:
I have a script that I need to run. The SQL script first creates a database called sampledb.
CREATE DATABASE `sampledb` 
I read in the docs that to start the Query Tool I need to pick Query Tool from the Tools menu. But the Query Tool is greyed out unless I have already chosen a database. I am concerned about running the script (which creates a database) since I am already in a database. Seems illogical. Can someone confirm that I can run my script in any of the existing databases with causing a major issue for myself? 

You should also consult the official PostgreSQL documentation, not just the documentation for your client program.


David J.

pgsql-novice by date:

Previous
From: Richard Bernstein
Date:
Subject: How to run a script with Query Tool?
Next
From: Tom Lane
Date:
Subject: Re: How to run a script with Query Tool?