postgreSQL max length restrictions

[buf]

Hi ALL.

Where can I find defined max length restrictions of postgreSQL,
such as max lengh of TEXT, VARCHAR,var-lenght ARRAY types, max query lenght and etc.

and can I set these parameters?

thanx in advance/

 

[rycamor]

See

http://www.postgresql.org/users-lounge/limitations.html

on the overal size limitations of a PostgreSQL database.

For specific datatype size limitations, see

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=datatype.html

I know this document isn't the clearest, but basically think of it this way: any datatype that doesn't have a specific limitation in its definition (int2, int4, int8, etc...) is only limited by the maxium size for a column (1 GB). So, TEXT, CHAR and VARCHAR can each be as large as 1 GB in size, along with BYTEA, DECIMAL, and NUMERIC. (see section Table 5-2 in the second link above)

As I understand it, then, an array of any type can hold as much as 1 GB of data in any one column of a row.

Obviously, binary large objects can be larger than 1 GB, but I believe are limited by the file size of the OS in question (maybe not...)

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html

 

[buf]

ok,

I understand.
10x for your reply.
it's so helpful/