Re: [SQL] query to file

2005-10-18 Thread Eugene E.
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 mean psql \o filename and try to read output of a command \? ---(end of broadcast)---

Re: [SQL] query to file

2005-10-18 Thread Michael Glaesemann
On Oct 19, 2005, at 8:03 , 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; You don't mention what client you're using. In psql, you can use \o path/to/file.txt F

Re: [SQL] query to file

2005-10-18 Thread Michael Fuhr
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

[SQL] query to file

2005-10-18 Thread Judith Altamirano Figueroa
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; ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choos