OKl. So it is clear that script to create the sample data is for mySQL. And I want to use it on postgresql. Is there any automated way to convert the script from mysql ro postgresql? Or do I need to learn enough about scripting (both for mysql and prostgresql )to manually make that change?
On Fri, Jun 19, 2020 at 12:09 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Richard Bernstein <richb201@gmail.com> writes: > 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 *must* connect to some existing database in the cluster to issue CREATE DATABASE. Doesn't matter which one.
The more interesting question is that your script probably then wishes to reconnect to the new database so it can do things there. I'm not sure how you'd do that in pgadmin (which I assume is what you're talking about). You might want to ask that question on a pgadmin-specific list, which this isn't.
