Re: [GENERAL] Creating Table Copy

2014-06-16 Thread Michael Paquier
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

Re: [GENERAL] Creating Table Copy [RESOLVED]

2014-06-16 Thread Rich Shepard
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