I have written the test trigger in language C. I know the compilation process given at http://developer.postgresql.org/pgdocs/postgres/xfunc-c.html#DFUNC but I don't know where and how to keep my "test.c" macro file? The test.c file is in my home drive and I also don;t know how to associate it with my database. I have connected to my PostgreSQL mydb database successfully.