Inserting an Encrypted file into DB - Mailing list pgsql-committers

From Smita Vijayakumar
Subject Inserting an Encrypted file into DB
Date
Msg-id 1192013339.14053.37.camel@smita.site
Whole thread Raw
Responses Re: Inserting an Encrypted file into DB  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-committers
Hi,
I want to put into the postgres DB, a file which is an encrypted file
(say, the PKCS# files).
I have used a bytea column for storing this file. So the operations with
regard to the file at my end are:
Filesystem ----> DB ------> Filesystem
What I need to know is:
1. Is there any information loss when the file is being transferred from
the filesystem to the DB?
2. If the answer is no, then does that mean that when the stream is
received from the DB, the file is an exact copy of the file which
existed? If so, the reverse key should be able to successfully decode
the stream received from the DB.

Kindly answer my query.
Thanks!

Smita


pgsql-committers by date:

Previous
From: meskes@postgresql.org (Michael Meskes)
Date:
Subject: pgsql: Synced parser and keyword list.
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: Inserting an Encrypted file into DB