PostreSQL SQL for MySQL SQL - Mailing list pgsql-general

From Chuck Esterbrook
Subject PostreSQL SQL for MySQL SQL
Date
Msg-id 5.0.2.1.0.20010206112901.02181190@mail.mindspring.com
Whole thread Raw
Responses Re: PostreSQL SQL for MySQL SQL
List pgsql-general
Hi,

I'm fairly new to PostreSQL, coming from MySQL. My Python application
generates these MySQL commands:

    drop database if exists Foo;
    create database Foo;
    use Foo;

Using the PostgreSQL online docs, my closest translation is:

    drop database Foo;
    create database Foo;

What I'm missing is:
    * "if exists" for the drop, in order to avoid an error the very first time
this program runs
    * the "use Foo;"

Can I do these things in PostreSQL from SQL (e.g., not from the command line)?


-Chuck


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Number of open files
Next
From: "Mitch Vincent"
Date:
Subject: Re: PostreSQL SQL for MySQL SQL