>I knew there had to be a way. I had forgotten about copy. I also think the redirection and pipe will work. Maybe I'm wrong. When working with triggers I never think of passing information to the outside world - just working with the database and tables.
>
>John

"select * from table > file.tx" may work inside of pgsql. ??? I may try it and see.