I don't know how to do it using psql but you could use pgadminIII from
www.pgadmin.org to connect to the database, view the tables and all the
triggers attached to it then. There is a linux version of it available
for free of course.
Mike
On Mon, 2004-06-14 at 23:31, sathish wrote:
> dear groups,
> how to view the trigger definition (i.e create trigger ....) which
> has already been created in the postgres. (iam working in linux terminal).
> yours sincerely,
> SathishKumar.S
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly