On Tue, Oct 18, 2005 at 06:03:59PM -0500, Judith Altamirano Figueroa wrote: > Excuse me, how can I send a query to a file?, for example the result of > this query: > > select id_articulo, articulo, color_code from articulos;
If you have a shell on a platform that supports input/output redirection then you could redirect psql's output: psql -c 'select ...' > filename >From within psql you could use \g or \o; see the documentation for more information. http://www.postgresql.org/docs/8.0/interactive/app-psql.html If you're using some other client then consult its documentation. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly