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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to