Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 4406331E987 for ; Fri, 6 Jan 2012 04:39:38 -0400 (AST) Received: from mail-iy0-f174.google.com ([209.85.210.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rj5Ko-0002ZC-Gs for pgsql-admin@postgresql.org; Fri, 06 Jan 2012 08:39:38 +0000 Received: by iaeh11 with SMTP id h11so2294089iae.19 for ; Fri, 06 Jan 2012 00:39:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; bh=KRKrzMYsMACUn91lWOMOq09/6u6QuVxBJKg5HveO3zY=; b=rHTmAf7mmfmP2yfhrQ6vM13btNPp/C3zxr2s0xNHrLpy6H0zG8oKNOI0qQL2k9FV+a 82cJCLJ46vKsveRzJwHSnJGQciHlsMww9xphaFY6rOD7G+1jWRsUkkSEUa4rkmcuRPnF k9/hNeKco7Di8Ux7GpNSbFKLJ3oXvWmax0RUE= Received: by 10.42.72.135 with SMTP id o7mr5226455icj.45.1325839162224; Fri, 06 Jan 2012 00:39:22 -0800 (PST) MIME-Version: 1.0 From: Misa Simic Date: Fri, 6 Jan 2012 00:39:21 -0800 Message-ID: <-4544684390160500629@unknownmsgid> Subject: Re: Reg: Insert bytea values in to table To: Hariraman Jayaraj , "pgsql-admin@postgresql.org" Content-Type: multipart/alternative; boundary=90e6ba6e87d04b302a04b5d7fc44 X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201201/36 X-Sequence-Number: 38948 --90e6ba6e87d04b302a04b5d7fc44 Content-Type: text/plain; charset=UTF-8 Hi INSERT INTO table( pdffile) VALUES (pg_readbinary_file('path_to_pdffile_on_server')) Sent from my Windows Phone ------------------------------ From: Hariraman Jayaraj Sent: 06/01/2012 08:04 To: pgsql-admin@postgresql.org Subject: [ADMIN] Reg: Insert bytea values in to table Hi, Postgres Version - 8.3 OS - Suse Linux 11 Enterprise Edition I have a requirement to store pdf files in db. I am suggested to use bytea data type to achieve this. I am having an table *ledger* with columns * id bigint, pdffile bytea *I want to store the pdf files in the pdffile column. Kindly suggest me how to do this. Thanks in advance. -- Regards, Hariraman Jayaraj Mobile - 9786228845 --90e6ba6e87d04b302a04b5d7fc44 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi

INSERT INTO table( pdffile) VALUES (pg_readbinary_f= ile('path_to_pdffile_on_server'))

Sent from my Windows Phone
From: Hariraman Jayaraj
Sent: 06/01/2012 08:04
To: = pgsql-admin@postgresql.org
Subject: [ADMIN] Reg: Insert bytea values in to table

Hi,

Postgres Version - 8.3
OS - Suse Linux 11 Enterprise Edition<= br>

I have a requirement to store pdf files in db. I am suggested to= use bytea data type to achieve this.

I am having an table ledger= with columns
id bigint,
pdffile bytea

I want to store the pdf files in the= pdffile column.
Kindly suggest me how to do this.
Thanks in advance= .

--
Regards,
Hariraman Jayaraj
Mobile - 978= 6228845


--90e6ba6e87d04b302a04b5d7fc44--