>E N9753
>
> Cheers,
> Murthy
>
> -Original Message-
> From: Jason Godden
> To: [EMAIL PROTECTED]
> Sent: 8/15/2003 7:33 PM
> Subject: Re: [GENERAL] summary and request
>
> create table import_contact (
> id character(7) not null primary key,
> fm ch
: [GENERAL] summary and request
create table import_contact (
id character(7) not null primary key,
fm character(30),
ls character(30),
addr character(30),
city character(25),
st character(2),
c character(1),
start decimal(6),
end decimal(6),
) WITHOUT OIDS;
cat datafile.dat | psql -dthedatabas
Just a note on that example:
I didn't properly end the case commands on the last two fields in the insert
and end should probably be quoted. No I haven't tested it. Should be:
echo "insert into contact select
id,
case fm when null then 'xzxzxzxz' else fm end,
case ls when null then 'xzxzxzxz'
On Sat, 16 Aug 2003 09:33:51 +1000
Jason Godden <[EMAIL PROTECTED]> wrote:
Ahh, thanks for this. And thanks to all the others that helped me on my way.
Hopefully I'll be able to give something back to the group. Although that
might be hard with all the experts here.
Perhaps I can document this
create table import_contact (
id character(7) not null primary key,
fm character(30),
ls character(30),
addr character(30),
city character(25),
st character(2),
c character(1),
start decimal(6),
end decimal(6),
) WITHOUT OIDS;
cat datafile.dat | psql -dthedatabase -c "copy import_contact from stdi
