Re: [GENERAL] Ignore when using COPY FROM

2000-10-16 Thread Bruce Momjian
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:

Re: [GENERAL] Ignore when using COPY FROM

2000-08-30 Thread Fredrick Bartlett
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. >

Re: [GENERAL] Ignore when using COPY FROM

2000-08-29 Thread Alfred Perlstein
> 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

Re: [GENERAL] Ignore when using COPY FROM

2000-08-29 Thread Adam Lang
: "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

[GENERAL] Ignore when using COPY FROM

2000-08-29 Thread Matthew Kennedy
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