Postgres Pro
Downloads
Home   >   mailing lists

creating a table from another table - Mailing list pgsql-general

From David O'Farrell
Subject creating a table from another table
Date
Msg-id 36E40DD0.51817780@aersoft.ie
Whole thread Raw
Responses Re: [GENERAL] creating a table from another table
List pgsql-general
Tree view 
-- 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                              AerSoft Limited
  mailto:dave.ofarrell@aersoft.ie              2 Northumberland Avenue,
                                               Dun Laoghaire,Co. Dublin
    Direct Phone 353-1-2145950
               Phone: 01-2301166   Fax: 01-2301167
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-general by date:

Previous
From: Vadim Valiakhmetov
Date:
Subject: Postgress case insensitive search on FreeBSD3.0
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] creating a table from another table