Current Query from Trigger

[Michael Fork]

All,

I am trying to create a basic auditing mechanism using
triggers and would like to create a table that
contains the following information:

audit_operation = TG_OP
audit_username = CURRENT_USER
audit_time = CURRENT_TIMESTAMP
audit_table = TG_RELNAME
audit_key = NEW.key_field (or OLD.key_field)
audit_statement = ??????

How can I get the SQL statement that triggered the
trigger?

Thanks.

Michael
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Luiz Rafael Culik Guimaraes]

Dear Friends

Does postgresql api has some function similar to mysql_real_escape_string()
?

Regards
Luiz

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Luiz Rafael Culik Guimaraes]

Dear Friends

Does postgresql api has some function similar to mysql_real_escape_string()
?

Regards
Luiz

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[CN]

> Does postgresql api has some function similar to

mysql_real_escape_string()
?

Manual 27.3.4 says that libpq has C function PQescapeString(). If that
function is not globally accessible, you might be able to build it from
its source code.

Regards,
CN

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[CN]

> Does postgresql api has some function similar to

mysql_real_escape_string()
?

Manual 27.3.4 says that libpq has C function PQescapeString(). If that
function is not globally accessible, you might be able to build it from
its source code.

Regards,
CN

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)