How to Secure or encrypt our Functions or business logic in postgres database?

panchraj · #1 (**permalink**) 12-26-11, 07:16

All of my business logics on in database in form of function triggers etc.
how i secure them by encrypting them by any technique or other suggestions for that purpose.

CarlosinFL · #2 (**permalink**) 12-29-11, 11:19

Your question is hard to understand...

Are you looking to encrypt the data from client to server using SSL or are you looking to encrypt the actual data within the tables?

panchraj · #3 (**permalink**) 12-29-11, 23:49

Quote:

Originally Posted by CarlosinFL

Your question is hard to understand...

Are you looking to encrypt the data from client to server using SSL or are you looking to encrypt the actual data within the tables?

no, i do not want both of them.

actually , i have made a lot of functions in postgres database.
i want that when anyone want to see these functions then he should not
able to do that.

and also when anyone takes backup and restore it in any other system then those functions must not be readable and understandable so than no one see logic code.

shammat · #4 (**permalink**) 12-30-11, 05:59

Quote:

Originally Posted by panchraj

actually , i have made a lot of functions in postgres database.
i want that when anyone want to see these functions then he should not
able to do that.

Not possible and not planned.
See Todo - PostgreSQL wiki (Features we do not want)

Internet Services

Web Development

Digital Marketing

Consumer Tech