Re: create table like syntax

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