query length
I've searched for an answer to this, and just can't seem to find it.
What is the maximum length of a query passed in via the c interface? I
found reference to the effect that via ODBC there is no limit, but didn't
know if it broke up really long statements.
Also, I don't mean individual select statements, but any sql query
statement, which could be several commands joined with a semi colon.
Thanks!
Unlimited. You will run out of memory first.
---------------------------------------------------------------------------
Timtohy wrote:
I've searched for an answer to this, and just can't seem to find it.
What is the maximum length of a query passed in via the c interface? I
found reference to the effect that via ODBC there is no limit, but didn't
know if it broke up really long statements.Also, I don't mean individual select statements, but any sql query
statement, which could be several commands joined with a semi colon.Thanks!
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073