Re: insert a value into a table

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: insert a value into a table
Date: 2005-10-21 15:45:06
Message-ID: 20051021154506.GA53678@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message SCassidy 2005-10-21 15:48:36 Re: a stored procedure ..with integer as the parameter
Previous Message Jonathan Gennick 2005-10-21 15:40:25 Re: [GENERAL] Oracle buys Innobase