The same, escaping double quotes inside the double quotes:
SELECT '"' || replace(replace(text_field,'\','\\'),'"','\"') || '"'
On Thu, Feb 23, 2012 at 15:16, Bill McCormick wrote:
> Yes, that should work.
>
> Thanks!!
> Dave Watkinson wrote, On 2/22/2012 5:33 PM:
>>
>>
Yes, that should work.
Thanks!!
Dave Watkinson wrote, On 2/22/2012 5:33 PM:
Did you mean something like
SELECT '"'||text_field||'"' FROM table;
so that your column's data is quoted?
~~~
Dave Watkinson
On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik wrote:
On
Did you mean something like
SELECT '"'||text_field||'"' FROM table;
so that your column's data is quoted?
~~~
Dave Watkinson
On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik wrote:
> On 2/22/2012 6:03 PM, Bill McCormick wrote:
>
>> What is the easiest way to return a
On 2/22/2012 6:03 PM, Bill McCormick wrote:
What is the easiest way to return a text field with double (") quotes?
SELECT quote(text_field) FROM table; is close, but I'd rather have a
SELECT double_quote(text_field) FROM table;
I'm not sure I understand the nature of the problem. What's wrong
On 22 Feb 2012, at 11:03pm, Bill McCormick wrote:
> What is the easiest way to return a text field with double (") quotes?
>
> SELECT quote(text_field) FROM table; is close, but I'd rather have a SELECT
> double_quote(text_field) FROM table;
Does
SELECT
5 matches
Mail list logo