Re: command length? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: command length?
Date
Msg-id 200206271601.08162.josh@agliodbs.com
Whole thread Raw
In response to command length?  (stev knowles <stev@Precision.Guesswork.COM>)
Responses Re: command length?  (stev knowles <stev@Precision.Guesswork.COM>)
new behavior  (stev knowles <stev@Precision.Guesswork.COM>)
List pgsql-novice
Stev,

> is there a limit to how long a *line* can be in a command? i understand
> that a command can continue across several lines, but is there a limit to
> the length of a line?

No, there is no limit.  Well, maybe 32,565 characters, but not less than that.

However, if you are talking about PSQL, your terminal application (such as
xterm or cygwin) may have a limit to the length of a line.

--
-Josh Berkus




pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: select 2 random rows
Next
From: Tom Lane
Date:
Subject: Re: NFS/NAS