Re: [GENERAL] creating a table from another table

1999-03-08 Thread Bruce Momjian
[Charset iso-8859-1 unsupported, filtering to ASCII...] > Hi Bruce and Dave. > > Am 08-Mar-99 schrieb Bruce Momjian: > >> is there any smart way to duplicate a table definition (NOT the > >> data in the table).I want to create table(s) from a predefined template > >> and drop them when they are

Re: [GENERAL] creating a table from another table

1999-03-08 Thread Karl Auer
Hi Bruce and Dave. Am 08-Mar-99 schrieb Bruce Momjian: >> is there any smart way to duplicate a table definition (NOT the >> data in the table).I want to create table(s) from a predefined template >> and drop them when they are empty . > > SELECT * INTO newone FROM table WHERE 1=0; I may be wr

Re: [GENERAL] creating a table from another table

1999-03-08 Thread Bruce Momjian
> > -- is there any smart way to duplicate a table definition (NOT the > data in the table).I want to create table(s) from a predefined template > and drop them when they are empty . > SELECT * INTO newone FROM table WHERE 1=0; -- Bruce Momjian| http://www.op.net/~

[GENERAL] creating a table from another table

1999-03-08 Thread David O'Farrell
-- is there any smart way to duplicate a table definition (NOT the data in the table).I want to create table(s) from a predefined template and drop them when they are empty . ~~ David O'Farrell