On Tue, Jun 17, 2014 at 5:51 AM, Rich Shepard wrote:
> I have a table with some NULL values in a date column. I need to make a
> copy of that table containing only those rows where the date column is not
> null. Reading the CREATE TABLE man page I've tried to create a copy of the
> original tabl
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