Re: copy commands and linefeeds - Mailing list pgsql-novice

Oliver:

thanks so much for the help. Just for folks who might be looking on the list,
Oliver's suggestion works with 8.1 and above:

    alter table mytable add check (mycolumn !~ E'[\n\r]');

whereas this works on 8.0:

    alter table mytable add check (mycolumn !~ '\\r\\n');

Maybe everyone already knows this...

Mija