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
[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