Replacing Tables

From: Greg Lindstrom <greg(dot)lindstrom(at)novasyshealth(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Replacing Tables
Date: 2006-01-03 14:35:19
Message-ID: 43BA8BA7.1090107@novasyshealth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

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.

Thanks for your help,
--greg

--
Greg Lindstrom 501 975.4859 (office)
Programmer 501 219-4455 (fax)
NovaSys Health greg(dot)lindstrom(at)novasyshealth(dot)com
Little Rock, Arkansas

"We are the music makers, and we are the dreamers of dreams." W.W.

Confidentiality Notice
----------------------
This email and any attachments to it are privileged and confidential and are intended solely for use of the individual or entity to which they are addressed. If the reader of this message is not the intended recipient, any use, distribution, or copying of this communication, or disclosure of all or any part of its content to any other person, is strictly prohibited. If you have received this communication in error, please notify the sender by replying to this message and destroy this message and delete any copies held in your electronic files. Thank you.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-01-03 15:14:42 Re: Replacing Tables
Previous Message me 2006-01-03 03:14:41 Re: dropping an unused sequence?