Re: General coding question

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of jkells
Sent: Tuesday, December 20, 2011 12:33 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] General coding question

General coding question.  Can I insert a text string into a character varying column that contains a \ as is, meaning no escaping of the character or is this a bad practice?

I.e:  Column                     data
    ==========              ====================================
    description              SUBDIV LOT 13 & N1\2 LOT  14 

Thanks

-----------------------------------------------------

You never would actually store an "escaping" black-slash in the data.  The need for an escape symbol occurs only during data entry and strictly depends on how you are entering data .  As you have not provided those details further advice cannot be given.  

David J.