Re: Creating Table Copy [RESOLVED] - Mailing list pgsql-general

On Mon, 16 Jun 2014, Rich Shepard wrote:

>  While I suspect there's a way to write a SELECT statement for those rows
> that are not null and save the results to a different table name, I've not
> found the syntax in my postgres and SQL references.

   Got it:

#  create table benthos as select * from benthosraw where sampdate is not
null;

Rich