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 по дате отправления: