Opa,

INSERT INTO foo VALUES ($$'teste'$$);

[]s

2008/7/22 Osvaldo Kussama <[EMAIL PROTECTED]>:

> 2008/7/22, Junin <[EMAIL PROTECTED]>:
> >
> > Como salvo num campo varchar um texto que contem aspas simples? ex.: ->
> > 'OBS'
> >
>
>
> Santo manual, Batman!
>
> Não é que lá eles explicam como fazer!
>
>
> http://www.postgresql.org/docs/current/interactive/sql-syntax-lexical.html#AEN1389
>
> - Also, a single quote can be included in an escape string by writing
> \', in addition to the normal way of ''.
> - Dollar-Quoted String, ex.: $$Dianne's horse$$
>
> Osvaldo
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>



-- 
João Paulo
www.dextra.com.br/postgres
PostgreSQL
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a