X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id CC3CE92547E for ; Wed, 28 May 2003 09:45:35 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 38420-10 for ; Wed, 28 May 2003 09:45:33 -0400 (EDT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by developer.postgresql.org (Postfix) with SMTP id DEC5B92538E for ; Wed, 28 May 2003 09:45:29 -0400 (EDT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Wed May 28 15:47:11 2003 +0200 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id PAA02135; Wed, 28 May 2003 15:45:23 +0200 (METDST) Message-ID: <3ED4BD73.C5C61B30@rodos.fzk.de> Date: Wed, 28 May 2003 15:45:23 +0200 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org, nishatreesa@hotmail.com Subject: Re: Large Objects Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/86 X-Sequence-Number: 4204 > > My application ,written in VC++ requires to copy data in a Microsoft Access > Database to > Postgres database,remotely. I have been using odbc Driver 7.02.005 with > Postgresql 7.3.2 . > > I need to transfer photographs stored as OLEObjecttype in a > Microsoft Aceess 2000 database to the Postgres database.Right now I am > using bytea type for storing photographs in the Postgresql database. > > I want to store the photographs as Large Objects in the Postgres database. > > Can anyone please help me regarding this?Can you provide with sample code > for this? > Nisha, Did you already go to http://techdocs.postgresql.org/guides/MSAccess I'm not familiar with stuff like that, but to me it looks like it's answering every question you might have. Regards, Christoph