Can someone tell me if this is correct, please?
create table cr_user(
user_id integer not null,
userid varchar(20) not null,
passwrd varchr(20) not null,
user_status char(1),
user_type char(2),
primary key(user_id),
check(user_status in ('A','I'),
check(user_type in ('HR','AP')));
The table creates, but /copy errors
with pg_atio: error in "AP" can't parse "AP"
I know it is the check as I can /copy the
data with a table created without the check.
Thanks in advance
Bill
