Re: Data format problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Data format problem
Date
Msg-id 12124.1008036400@sss.pgh.pa.us
Whole thread Raw
In response to Data format problem  ("Verbus M. Counts" <verbus@sonicisp.net>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Rich Ryan"
Date:
Subject: Re: Vacuum errors and warnings
Next
From: Stephan Szabo
Date:
Subject: Re: Data format problem