Re: Replacing Tables

On 1/3/06 9:35 AM, "Greg Lindstrom" <greg(dot)lindstrom(at)novasyshealth(dot)com>
wrote:

> Greetings-
> Is there a postgres equivalent to the CREATE OR REPLACE TABLE ....
> command in MySQL? I've looked trough the docs and can't find it.

Nope. The usual answer given is to just do the DROP TABLE as usual and know
that it will fail if the table doesn't exist--no big deal as long as this
occurs in its own transaction. Then, CREATE the table as usual.

> Also, I have been using plpgsql to generate stored procedures; are there
> tutorials or manuals available? Again, I've been looking for books on
> Amazon, O'Reilly, and Sams but can't find much on plpgsql. I have a
> library of about 40 routines which generate XML from my database and
> would like to know more about the language.

Have you looked at the postgres documentation? Is there a specific aspect
of the language that you would like more information on?

Sean