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) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org