Re: create table like syntax

[Gaetano Mendola <mendola@xxxxxxxxxxx>]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org