Paul Lambert wrote on 06.02.2007 23:44:
Sort on Weenblows is a bastard to work with, and I don't believe it has
a unique option. I probably should have mentioned this was on Weenblows.
You can get all (or most?) of the *nix/GNU commandline tools for Windows as
well. As "native" Win32 progra
As the table definitions get updated frequently, I'd like to put in my
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 tab
Andrew Sullivan wrote:
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
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.
