number characters on the command line

Поиск
Список
Период
Сортировка
От Keith D. Evans
Тема number characters on the command line
Дата
Msg-id 44A453E9.8010005@umbc.edu
обсуждение исходный текст
Список pgsql-novice
Dear novices,

I searched the database but none of questions/answers seemed to apply to
this problem.

I am using select to select data (duh!) but I am specifying a large
WHERE clause to localize my search. It seems that when I have entered
more than 256 characters and hit enter, I get a syntax error at or near
character 1. When I do \p, to display the query, it shows the portion of
the command that exceeds the max query length (which is how I discovered
the max length). How can I use more than 256 characters in my select
command?

I am using 7.4.1.

thanx,
keith

--
"Every magnificent history begins with something small."  Daisaku Ikeda
=======================================================
Keith D. Evans
Joint Center for Earth Systems Technology/UMBC
(301) 614-6282 (M,Tu)
(410) 455-5751 (W,Th,F)
http://www.jcet.umbc.edu/bios/evanmain.html
========================================================

Any opinions expressed in this email are not those of
NASA, or the Goddard Space Flight Center, or the Joint
Center for Earth Systems Technology or the University
of Maryland Baltimore County.

========================================================



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

Предыдущее
От: "nitin quick"
Дата:
Сообщение: Re: postgres in realtime mode
Следующее
От: "Garcia, Joshua"
Дата:
Сообщение: Re: insert more than one rows