create table like syntax

From: David Durham <ddurham(at)vailsys(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: create table like syntax
Date: 2005-10-06 03:04:10
Message-ID: 4344942A.3040506@vailsys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2005-10-06 03:29:35 Re: archive_command
Previous Message Hui Zhou 2005-10-05 21:42:35 RPMs for RedHat ES3.0 - installation problem