problem copying a table

#11

"Laurenz Albe" <invite (AT) spam (DOT) to.invalid> schreef in bericht
news:1160550550.964123 (AT) proxy (DOT) dienste.wien.at...

Quote:

HansH <hans (AT) somewhere (DOT) invalid> wrote:
Or it's a typo -( misplaced -: try
CREATE TABLE MyTable LIKE ( MyOldTable );

Your are guessing, right?
NO, and wrong the more :-(

CREATE TABLE new ( LIKE old ) INHERIT ( other, another )

This additon -per version 7.4- to CREATE TABLE does has its first ( placed
_before_ a keyword.
At first sight that looks odd, however these () normally enclose column
definition and that's what 'like ...' does here too.

ISC

HansH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

problem copying a table

comp.databases.postgresql comp.databases.postgresql

Re: problem copying a table - 10-11-2006 , 08:52 AM