[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

Re: [GENERAL] (redefinition) alter table, add foreign key constraint

2000-10-17 Thread Matthew Kennedy
[EMAIL PROTECTED] wrote: > On Tue, 17 Oct 2000, Matthew Kennedy wrote: > > Is it possible to perform an alter table with add foreign key constraint > > in PostgreSQL? We are trying to support multiple DBMS in our project by > > keeping to a common, compatible denominator. Or