Arunachalam Parthasarathy wrote:
hi, i would request you to answer the following query:1. What is the maximum size of data single Bytea entry in column? i would be thankful to you for the above request . P.S : my current reqirement is to add more that 1 gb of data in a single entry of type bytea column in each row. Thanks and regards Arunachalam ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
bytea uses up to 4 bytes to represent the binary string length (signed 32-bit integer). So the max data size is 2G.
http://www.postgresql.org/docs/8.3/static/datatype-binary.html andrew ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
