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
Well, you could always make a table that has no constraints on duplicates and COPY TO that one. Then, make a query that inserts the data into your production table that handles the duplicates. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Matth