| From: | "Sim Zacks" <sim(at)compulab(dot)co(dot)il> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: double quotes inside VBA string ? |
| Date: | 2005-05-23 07:39:09 |
| Message-ID: | d6rtt0$20f0$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
double up the double quotes. "select * from public.""Customers"""
In any case, I agree with jeff, make your table names lowercase and leave out the quotes.
Sim
"Zlatko Matić" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> wrote in message news:001d01c55bab$87607cf0$99301dc3(at)zlatkovyfkpgz6(dot)(dot)(dot)
Hello.
I have a problem when working with MS Access/PostgreSQL.
Namely, as PostgreSQL syntax uses doble quotes for table names and field names, when I write it as a string of a pass-through query or Command text of ADO Command object it looks like:
"select * from public."Customers""
and VBA considers that the first quote after public. is the end of statement.
How to solve it ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick.FICHE | 2005-05-23 08:12:36 | How to recover from : "Cache lookup failed for relation " |
| Previous Message | Jim C. Nasby | 2005-05-23 00:28:14 | Re: table synonyms |