Re: [GENERAL] max query length

From: Marc Tardif <admin(at)wtbwts(dot)com>
To: dean browett <dbrowett(at)bizonline(dot)net>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] max query length
Date: 2000-02-04 12:21:51
Message-ID: Pine.BSF.4.10.10002041220260.73844-100000@server.b0x.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think there is no maximum on the actual query length, but there is a
limit on the max row size. If I remember correctly, there is an 8k limit
to the contents of an entire row. If you need more than that, either split
your data across multiple rows are use the blob data type.

Marc

On Fri, 4 Feb 2000, dean browett wrote:

> Hi,
>
> Can anyone tell me whether there is a maximum query length using 'insert'?
>
> We want to insert a text statement into our db. This statement may be up to
> 20k in size.
>
> Dean
>
>
>
>
>
> ************
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dean browett 2000-02-04 12:40:30 max query length
Previous Message Yury Don 2000-02-04 10:39:31 pl/pgsql and national characters