Re: create table like syntax

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: David Durham <ddurham(at)vailsys(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: create table like syntax
Date: 2005-10-06 03:36:36
Message-ID: 20051006033636.GA12593@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Oct 05, 2005 at 10:04:10PM -0500, David Durham wrote:
> is there a syntax that would look something like:
>
> create table newTable like oldTable without indexes || records ||
> constraints with indexes || records || constraints
>
> built into postgres?

What do you want to do with it? If I understand what you want to do, it
is supported as long as you use ; in place of your ||.

--
Alvaro Herrera Architect, http://www.EnterpriseDB.com
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dedy 2005-10-06 04:54:40 faster or ..... ????
Previous Message Jeff Frost 2005-10-06 03:29:35 Re: archive_command