Devart Forums

Hi,

I'm having some trouble handling PostgreSQL views that contain single quotes, for instance "this is a 'quoted' query". I can retrieve the metadata OK (ie. the names of all views in the database), but as soon as I try to retrieve the definition (ie. the SQL statement), it seems I cannot pass the name of the query to the database without it being cut off at the first quote.

I'm escaping single quotes by replacing all single quotes with 2 single quotes.

Any suggestions?

kind regards,
Jan

Hello,

We have reproduced the problem.
We will notify you as soon as we have any results.

Hello

We have fixed this bug. This fix will be included in the next PgDAC build.