Re: Creating Table Copy [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating Table Copy [RESOLVED]
Date: 2014-06-16 20:55:42
Message-ID: alpine.LNX.2.11.1406161354440.28452@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sunpeng 2014-06-17 01:10:57 How to store fixed size images?
Previous Message Rich Shepard 2014-06-16 20:51:13 Creating Table Copy