At 10:56 AM 5/17/2001 -0400, Jeff Johnson wrote:
>PostgreSQL 7.1, released a month ago, adds support for views and SQL92
>join syntax! Now I can port my MS SQL Server database over and most
>of my SQL should work without modification :)
Does it support "drop database if exists Foo;" and other uses of "if
exists" or "if not exists".
Does it support "use" as in "use Foo;"?
Reason I ask is that when attempting to port from MySQL to PostgreSQL, I
ran into these missing features and while they can certainly be worked
around, porting (and SQL in general) is more convenient with them.