Re: output a single and double quote in a string

On Fri, Mar 18, 2005 at 05:13:32PM -0600, George Weaver wrote:
>
> SELECT length_ft::text || chr(39)
>        length_in::text || \' " \' AS length_dim,
>        width_ft::text || chr(39) ||
>        width_in::text || \' " \' AS width_dim
>   FROM sales_order.tbl_net_production;

Not quite -- that produces errors because of a missing || operator
and single quotes that shouldn't be escaped (at least not in a
standalone query).  Perhaps you meant this:

SELECT length_ft::text || chr(39) ||
       length_in::text || '"' AS length_dim,
       width_ft::text || chr(39) ||
       width_in::text || '"' AS width_dim
  FROM sales_order.tbl_net_production;

Other examples:

SELECT '\'' AS single_quote, '"' AS double_quote;
SELECT '''' AS single_quote, '"' AS double_quote;
SELECT $$'$$ AS single_quote, $$"$$ AS double_quote;  -- 8.0 and later

See "String Constants" in the "SQL Syntax" chapter of the documentation:

http://www.postgresql.org/docs/8.0/interactive/sql-syntax.html#SQL-SYNTAX-CONSTANTS

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/