SQL query to a file

Hi All,

I have a connection to a PostgreSQL database, and I would to write a query
result to a file.

Example:
# ----8<----------------------------------------------
$conection = pgconnect(...
$sql = "select * from mytable";
$result = pg_exec($conection, $sql);
# -----8<---------------------------------------------

So, the results are stored in $result, how can I write this to a file?

Thanks in advance,

Marcelo Pereira

-- Remember that only God and Esc+:w saves.
__
(_.\ Marcelo Pereira |
/ / ___ |
/ (_/ _ \__ Matematica/99 - IMECC |
_______\____/_\___)___Unicamp_______________/