Re: [GENERAL] Re: PostreSQL SQL for MySQL SQL

2001-02-07 Thread fabrizio . ermini
On 6 Feb 2001, at 14:24, Chuck Esterbrook wrote: > At 01:10 PM 2/6/2001 -0600, John Burski wrote: > >interactively, via psql, via the Perl Pg module, or via PHP. If you > >attempt to drop a database that doesn't exist, PostgreSQL will issue an > >error message. If you're running interactively

Re: [GENERAL] Re: PostreSQL SQL for MySQL SQL

2001-02-06 Thread Dan Wilson
: I think it's still a good idea to provided the "if exists" clause in a : future PostgreSQL version for these reasons: : 1. it's convenient : 2. it doesn't interfere with existing functionality or performance : 3. it makes porting from MySQL to PostgreSQL easier I seco

[GENERAL] Re: PostreSQL SQL for MySQL SQL

2001-02-06 Thread Mitch Vincent
> 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; You supply the