Re: Removing duplicate rows

On Wed, Feb 07, 2007 at 07:15:02AM +0900, Paul Lambert wrote:
>
> I'm assuming the best way to get around this is to load the data into a
> temporary table with "copy from" and then do a "select distinct into" my
> real table.

You might find that sort|uniq at the command prompt would be better.
That said,

> script to create the table as a copy of the existing 'real' table. I'm
> assuming "create table as" would be what I need to use, but what would I
> use as the select sql - i.e. how do I use select to pull the definition
> of a table.

an easy way to do this is "CREATE TABLE name AS SELECT . . . WHERE
1=0". You get a table with no rows. (WHERE FALSE and similar
constructs all work equally well.)

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland