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