Postgres Pro
Downloads
Home   >   mailing lists

Re: insert a value into a table - Mailing list pgsql-general

From Michael Fuhr
Subject Re: insert a value into a table
Date
Msg-id 20051021154506.GA53678@winnie.fuhr.org
Whole thread Raw
In response to insert a value into a table  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
Tree view 
On Fri, Oct 21, 2005 at 08:29:44PM +0530, surabhi.ahuja wrote:
>  i have a fiels - varchar(100)
>
> to this fiels i am trying to insert
>
> "abc\def\xyz'
>
> but it is not inserting the whole thing ...

See "String Constants" in the documentation and take particular
note of what it says regarding backslashes:

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

--
Michael Fuhr

pgsql-general by date:

Previous
From: "Larry Rosenman"
Date:
Subject: Re: insert a value into a table
Next
From: SCassidy@overlandstorage.com
Date:
Subject: Re: a stored procedure ..with integer as the parameter