Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] INSERT INTO: string with apostrophe - Mailing list pgsql-general

From Rich Shepard
Subject [GENERAL] INSERT INTO: string with apostrophe
Date
Msg-id alpine.LNX.2.11.1706291259071.846@localhost
Whole thread Raw
List pgsql-general
Tree view 
   The syntax for inserting data into a table uses single quotes to identify
strings. When I have a string such as O'Brien do I double the single quotes
within the string (i.e., 'O''Brien') or is there another way to include such
strings?

Rich

pgsql-general by date:

Previous
From: Ilya Roublev
Date:
Subject: [GENERAL] Connecting matlab with postgresql
Next
From: Devrim Gündüz
Date:
Subject: Re: [GENERAL] Download 9.6.3 Binaries