Skip site navigation (1) Skip section navigation (2)

Re: command length?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: stev knowles <stev(at)Precision(dot)Guesswork(dot)COM>,Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: command length?
Date: 2002-06-27 23:01:08
Message-ID: 200206271601.08162.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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




In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2002-06-28 03:55:49
Subject: Re: NFS/NAS
Previous:From: Josh BerkusDate: 2002-06-27 22:58:00
Subject: Re: select 2 random rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group