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?
Try this:

create table newTable as
select * from oldTable limit 0;



Regards
Gaetano Mendola

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 4 | next ›
Discussion Overview
grouppgsql-admin @
categoriespostgresql
postedOct 6, '05 at 3:04a
activeOct 7, '05 at 2:48p
posts4
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase