[ADMIN] Blob Data type in postgres ?
Hi , I would like tocreate a table with blob as a datatype.I found that postgres doesn't have a datatype called BLOB. Is there any equivalent data type for this or a short cut ? I appreciate if some one can help me in this regard. Thank you all, Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: sbangalore@zensutra.com Weaving the knowledge tapestry'
Re: [ADMIN] Blob Data type in postgres ?
have a look at bytea regards -andreas On Friday 05 September 2003 12:41, Somasekhar Bangalore wrote: Hi , I would like to create a table with blob as a datatype.I found that postgres doesn't have a datatype called BLOB. Is there any equivalent data type for this or a short cut ? I appreciate if some one can help me in this regard. Thank you all, Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: [EMAIL PROTECTED] Weaving the knowledge tapestry' -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Blob Data type in postgres ?
As far as I am concerned, I think that lobs are managed in postgres with oid. Create your table like this : CREATE TABLE table_of_lobs ( title varchar(100), content_reference oid); content_reference is a handler on lobs data contained in specials postgres system tables called Toast. Create a rule to automatically destroy LOB data when you delete a tuple in table_of_lobs : CREATE RULE del_table_of_lobs AS ON DELETE TO table_of_lobsDO SELECT lo_unlink(old.content) AS lo_unlink; Once you've created your table, use lo_import/lo_export functions to import/export your LOB data in a pgsql session (you must be super useer) or use LOBS management functions available in libpq in order to interface lobs data management in your favorite program language. Regards, Luc Jouneau - Original Message - From: Somasekhar Bangalore To: [EMAIL PROTECTED] Sent: Friday, September 05, 2003 12:41 PM Subject: [ADMIN] Blob Data type in postgres ? Hi , I would like tocreate a table with blob as a datatype.I found that postgres doesn't have a datatype called BLOB. Is there any equivalent data type for this or a short cut ? I appreciate if some one can help me in this regard. Thank you all, Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: sbangalore@zensutra.com Weaving the knowledge tapestry'