Tb...
INSERT INTO foo VALUES ('\'teste\'');
2008/7/22 jota. comm <[EMAIL PROTECTED]>:
> 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
>
>
--
VALTER CEZAR PRADO JUNIOR
GRADUADO EM CIÊNCIA DA COMPUTAÇÃO - UFOP
ANALISTA DE SISTEMAS - BYSAT
DBA / PROJETISTA DE SISTEMAS - PBH
Sem saber como fazer ele fez!
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
