bolb data type

[Gagan Anand]

Hello,
i have data in form of images which are in GB's,
i need to store the extracted data from the images.
This will required large fields size.
I was thinking of Blob data type as we have in
Oracle. Do we have blob data type in postgreSQL, if
yes in which version.

Thank's
Gagan Anand
India.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[DeJuan Jackson]

Gagan Anand wrote:

Hello,
i have data in form of images which are in GB's,
i need to store the extracted data from the images.
This will required large fields size.
I was thinking of Blob data type as we have in
Oracle. Do we have blob data type in postgreSQL, if
yes in which version.

Thank's
Gagan Anand
India.

See: large objects, bytea, and text all of which can store 2GB or more
as of 7.3X.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[DeJuan Jackson]

Gagan Anand wrote:

Hello,
i have data in form of images which are in GB's,
i need to store the extracted data from the images.
This will required large fields size.
I was thinking of Blob data type as we have in
Oracle. Do we have blob data type in postgreSQL, if
yes in which version.

Thank's
Gagan Anand
India.

See: large objects, bytea, and text all of which can store 2GB or more
as of 7.3X.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match