Added to TODO:
* Allow COPY to specify column names
> Yes, I have same problem. This functionality is "almost" standard,
> and
> found on other RDBMS. How do new features get added to the todo list's.
> Where can I view the current todo list?
>
> Fredrick
>
> Matthew Kennedy wrote:
Yes, I have same problem. This functionality is "almost" standard,
and
found on other RDBMS. How do new features get added to the todo list's.
Where can I view the current todo list?
Fredrick
Matthew Kennedy wrote:
> I have a ton of data in a text delimited file from an old legacy system.
>
> From: "Matthew Kennedy" <[EMAIL PROTECTED]>
> > I have a ton of data in a text delimited file from an old legacy system.
> > When uploading it into postgres, I'd do something like this:
> >
> > COPY stuff FROM 'stuff.txt' USING DELIMITERS = '|';
> >
> > The problem is some of the rows in stuff.t
: "Matthew Kennedy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 10:15 AM
Subject: [GENERAL] Ignore when using COPY FROM
> I have a ton of data in a text delimited file from an old legacy system.
> When uploading it into postgres, I'd do so
I have a ton of data in a text delimited file from an old legacy system.
When uploading it into postgres, I'd do something like this:
COPY stuff FROM 'stuff.txt' USING DELIMITERS = '|';
The problem is some of the rows in stuff.txt may not conform to the
stuff table attributes (duplicate