On Fri, 21 Jul 2006, David Wheeler wrote:
> Well, unless they have a dumb XML parser, those quotation marks won't be
> in the SQL schema. Does \d account_status_record_status show the quotation
> marks? But yeah, the use of single quotes for identifiers is valid in
> MySQL but not in PostgreSQL, as you note.
No, \d+ shows no identifiers with quotation marks.
I'll hold off on the sigle quotes for now.
> Sounds about right. But I'd try to copy a query into psql to make sure
> that it really doesn't work, first, just to be positive before you spend
> all that time!
OK. I'll start with the file that threw the error and work back to find a
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
In response to
pdxpug by date
|Next:||From: Selena Deckelmann||Date: 2006-07-29 14:52:27|
|Subject: postgresql & PAM auth on Mac OS X|
|Previous:||From: Rich Shepard||Date: 2006-07-21 19:56:57|
|Subject: Re: Additional Help Desired in Application Port to PostgreSQL|