From: Kumar <sgnerd@yahoo.com.sg>
To: psql <pgsql-sql@postgresql.org>
Subject: Large Objects and Bytea
Date: Thu, 25 Sep 2003 09:41:28 +0530
Message-ID: <00f701c3831b$242f2150$7502a8c0@hdsc.com> (raw)
Hi Friends,
I am running Postgres 7.3.4 on RH Linux 7.2.
I am migrating MS SQL DB to Postgres DB. I have tables with columns of data type 'Image' in the MS SQL database.
IF I choose 'bytea' datatype, I am afraid it may lead to poor performance of the database (which I read from the manual). In this case what is the best data type to use.
Please suggest me. The explanation of using LOB objects in a table and to write them with image is not very clear in the documentation. Can any one send me any link or white paper or examples about it.
Thanks in advance.
Kumar
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg
Subject: Re: Large Objects and Bytea
In-Reply-To: <00f701c3831b$242f2150$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox