Re: How to run a script with Query Tool?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to run a script with Query Tool?
Дата
Msg-id CAKFQuwa8nEGfhyPwktFHYE4OFE7ffGFD_EQEMZGwk+4=2pWf2Q@mail.gmail.com
обсуждение исходный текст
Ответ на How to run a script with Query Tool?  (Richard Bernstein <richb201@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Richard Bernstein
Дата:
Сообщение: How to run a script with Query Tool?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to run a script with Query Tool?