double quotes inside VBA string ? - Mailing list pgsql-general

From Zlatko Matić
Subject double quotes inside VBA string ?
Date
Msg-id 001d01c55bab$87607cf0$99301dc3@zlatkovyfkpgz6
Whole thread Raw
Responses Re: double quotes inside VBA string ?
List pgsql-general
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 ?


pgsql-general by date:

Previous
From: "Sim Zacks"
Date:
Subject: plpython multi row return workaround
Next
From: Michael Fuhr
Date:
Subject: Re: Executing Dynamic DDL