Обсуждение: Escape Quotes

When using apostrophies the PostgreSQL string seems to like 
an escape character as follows:

update client set code = 'O\'SHEA' where clientid = 2;


The ANSI-92 standard seems to suggest that this could/should 
be handled by 

<quote> ::= '
<quote symbol> ::= <quote><quote>
update client set code = 'O''SHEA' where clientid = 2;


Is it possible to get/configure PostgreSQL to handle <quote><quote>
as <quote> within a dleimited string?


Keith Gray

Keith Gray <keith@heart.com.au> writes:
> Is it possible to get/configure PostgreSQL to handle <quote><quote>
> as <quote> within a dleimited string?

We already do.

regression=# select 'O''SHEA';?column?
----------O'SHEA
(1 row)

        regards, tom lane

Keith Gray <keith@heart.com.au> writes:
> This may be a problem in "ipgsql" then??

I guess.  What is that, anyway?

> ...or is it different in update from select?

Nope, a literal is a literal.
        regards, tom lane

Tom Lane wrote:
> 
> Keith Gray <keith@heart.com.au> writes:
> > Is it possible to get/configure PostgreSQL to handle <quote><quote>
> > as <quote> within a dleimited string?
> 
> We already do.
> 
> regression=# select 'O''SHEA';
>  ?column?
> ----------
>  O'SHEA
> (1 row)
> 
>                         regards, tom lane
Sorry,

This may be a problem in "ipgsql" then??
...or is it different in update from select?

Keith

> > > Is it possible to get/configure PostgreSQL to handle <quote><quote>
> > > as <quote> within a delimited string?
> >
> > We already do.
> >
> 
> This may be a problem in "ipgsql" then??
> ...or is it different in update from select?


The problem is in ipqsql... 
it doesn't handle update, but does handle select.

Both work fine for psql (linux).


Keith.

On Fri, May 11, 2001 at 01:17:41PM +1000, Keith Gray wrote:
> 
> The problem is in ipqsql... 
What the heck is ipsql??
-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net      http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
 
In Borland you are never bored!

Roberto Mello wrote:
>
>         What the heck is ipsql??
>
>         -Roberto

ipgsql

A Win32 client for interactive Postgres session


Keith                            README

Interactive PostgreSQL presents comfortable windows environment
to execute sql queries, edit tables data, view tables list and
structure, execute sql scripts, etc.

This application design on Delphi using PostgreSQL components,
which included in Winzeos Library:
http://www.zeos.dn.ua/download/winzeos-latest.zip

                       PARAMETERS

  Connect parameters for Interactive PostgreSQL stored in the
ipgsql.ini file in the same directory that ipgsql.exe
  You can change its manually or using File/Options dialog
  Parameters short description:

[Preferences]
  PgSQLPort=<N>        ; PostgreSQL port number (default 5432)
  IsAlive=1        ; Open alive queries  (default 1)
  IsCached=0        ; Use cached updates  (default 0)
  QueryAll=0        ; Query all records when open (default 0)
  AutoCommit=0        ; Auto commit updates (default 0)
  AutoRecovery=0    ; Auto rollback transaction when
            ; errors occured      (default 1)
  Login=<login>        ; PostgreSQL login    (no default)
  Host=<host name>    ; Host name           (no default)
  DataBase=<db name>    ; Database name       (no default)

                     EXTRA FEATURES

Program supports PostgreSQL Large Objects. In postgreSQL
database they represented as Oid fields which store LO handle.
In IPgSql these fields translate to Blob field.
You may store in Blob fields text, images or any binary data.
Open blob field editor by double click in grid or choose
View/Blob Editor menu item.

                       LICENCING

Zeos Library is distributed with the GPL licence and
costs you nothing.

                       DOWNLOADS

The latest version can be found on:
  http://www.zeos.dn.ua/download/ipgsql-latest.zip

                        KNOWN BUGS

1. When your sql query crash and AutoRecovery set to false
   end transaction manually.
   If AutoRecovery set to true after crash transaction
   is auto rollbacked.
2. IPgSql works only with PostgreSQL 6.5+

                          CREDITS

- Steve Wei for idea and support designing PostgreSQL components

Yours,
  Sergey Seroukhov, Chief Engineering of Capella Development Group.
  <voland@kita.dgtu.donetsk.ua>