Re: [GENERAL] max query length - Mailing list pgsql-general

From Marc Tardif
Subject Re: [GENERAL] max query length
Date
Msg-id Pine.BSF.4.10.10002041220260.73844-100000@server.b0x.com
Whole thread Raw
In response to max query length  (dean browett <dbrowett@bizonline.net>)
List 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
>
>
>
>
>
> ************
>
>


pgsql-general by date:

Previous
From: "Barnes"
Date:
Subject: RE: [GENERAL] using ID as a key
Next
From: Marc Tardif
Date:
Subject: Re: [GENERAL] using ID as a key