Обсуждение: CREATE DATABASE ENCRYPTED ?

I apologize in advance if I'm remembering incorrectly or am missing
something right under my nose, but I thought there used to be an option
for creating a database or table in which all the data was stored
encrypted, something like "CREATE DATABASE dbname ENCRYPTED" or "CREATE
TABLE tname ENCRYPTED", but now I can't find that in the documentation
anywhere. The only thing close I've located is the "ENCRYPTED" option for
the password in "CREATE USER".  I know there is the pg_cyrpt library for
and related functions, but where (if it exists) is that functionality for
database-wide encryption ... or am I thinking of some database product
other than Postgresql?

--
Berend Tober

btober@seaworthysys.com writes:
> I apologize in advance if I'm remembering incorrectly or am missing
> something right under my nose, but I thought there used to be an option
> for creating a database or table in which all the data was stored
> encrypted, something like "CREATE DATABASE dbname ENCRYPTED" or "CREATE
> TABLE tname ENCRYPTED", but now I can't find that in the documentation
> anywhere.

Nope, never been any such thing in Postgres --- maybe you're thinking of
the facility for encrypted passwords?

My suggestion would be to use an encrypting filesystem layer.

            regards, tom lane