| Lists: | pgsql-novice |
|---|
| From: | "Winson Yung" <winson(dot)yung(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | how to encrypt trigger function |
| Date: | 2006-04-05 21:22:18 |
| Message-ID: | 48413e3e0604051422r11534cc9s121d1e5a62395041@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Just curious whether there is such feature in postgres that allows you to
encrypt the trigger function. I don't want to expose the trigger function
content to the curious mind. Any suggestion will be much appreciated.
/Weng
| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Winson Yung <winson(dot)yung(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: how to encrypt trigger function |
| Date: | 2006-04-11 01:20:19 |
| Message-ID: | 5CE5EAFC-0F5F-42ED-BCAC-BD566A81C171@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
On Apr 5, 2006, at 5:22 PM, Winson Yung wrote:
> Just curious whether there is such feature in postgres that allows
> you to encrypt the trigger function. I don't want to expose the
> trigger function content to the curious mind. Any suggestion will
> be much appreciated.
Not for SQL or pl/pgsql functions. You could write it in C and
compile it.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From: | "Winson Yung" <winson(dot)yung(at)gmail(dot)com> |
|---|---|
| To: | "John DeSoi" <desoi(at)pgedit(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: how to encrypt trigger function |
| Date: | 2006-04-11 05:31:30 |
| Message-ID: | 48413e3e0604102231v6fa22eci8c233e80f452c4fd@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
I am not sure how to do it in C, could you give an example?
thanks
On 4/10/06, John DeSoi <desoi(at)pgedit(dot)com> wrote:
>
>
> On Apr 5, 2006, at 5:22 PM, Winson Yung wrote:
>
> > Just curious whether there is such feature in postgres that allows
> > you to encrypt the trigger function. I don't want to expose the
> > trigger function content to the curious mind. Any suggestion will
> > be much appreciated.
>
> Not for SQL or pl/pgsql functions. You could write it in C and
> compile it.
>
>
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Winson Yung <winson(dot)yung(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: how to encrypt trigger function |
| Date: | 2006-04-11 12:37:18 |
| Message-ID: | 809C3408-742C-435D-BE7E-B99EDF40C2DE@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
On Apr 11, 2006, at 1:31 AM, Winson Yung wrote:
> I am not sure how to do it in C, could you give an example?
The PostgreSQL documentation has an example here:
http://www.postgresql.org/docs/8.1/interactive/trigger-example.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL