> echo "insert into titles"
> psql testdb <<EOF
> insert into titles
> values ('BU1111',
> 'Cooking with Computers: Surreptitious Balance Sheets',
> 'business',
> '1389',
> $11.95,
> $5000.00,
> 3876,
> 'Helpful hints on how to use your electronic resources to the best
> advantage.', '06/09/88', 1);
>
> insert into titles
> values ('MC2222',
> 'Silicon Valley Gastronomic Treats',
> 'mod_cook',
> '0877',
> $19.99,
> $0.00,
> 2032,
> 'Favorite recipes for quick, easy, and elegant meals, tried and tested
> by people who never have time to eat, let alone cook.',
> '06/09/89', 1);
> EOF
> When I change the $0.00 to $1.00 all works well????????????
I think you don't want those $ in front of the amounts.
Try doing a
cat <<EOF
<data from above>
EOF
and seeing what it gives you. My guess is that it's replace
the $<n> with something. In the case of $0 it's probably the program
name.