Re: Quotation marks in queries

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Quotation marks in queries
Дата
Msg-id 20050720151824.GA26457@svana.org
обсуждение исходный текст
Ответ на Re: Quotation marks in queries  (teknokrat <teknokrat@yahoo.com>)
Ответы Re: Quotation marks in queries  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список pgsql-general
On Wed, Jul 20, 2005 at 12:43:48PM +0100, teknokrat wrote:
> The problem we have is that we want to migrate to postgresql from our
> current sql server db, but the problem with caps requiring quotes around
> them makes this a far from easy migration.

The rule is pretty much, either always quote or never quote. Once you
start mixing and matching you're likely to get screwed.

So, if you don't use quotes in the CREATE TABLE statement, you'll never
have to quote anywhere else either...

Have this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Dan Armbrust
Дата:
Сообщение: Slow Inserts on 1 table?
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: Quotation marks in queries