"Verbus M. Counts" <verbus@sonicisp.net> writes:
> 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);
Those dollar signs should not be there; they are not noise, as you
seem to think. I suspect that your shell script interpreter is
substituting something for them.
regards, tom lane