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