Re: [pgadmin-support] Output to file

2010-02-28 Thread Guillaume Lelarge
Le 27/02/2010 23:04, John Gage a écrit : > Is there a way to have sequential SELECT queries output to the same file > without having the second SELECT overwrite the first. > > Here is a sample: > > SELECT * FROM prof_texts_lines WHERE source_lines ~* '(enregistrement)' > ORDER BY line_no ; > > S

Re: [pgadmin-support] Output to file

2010-02-27 Thread John Gage
It appears that using psql directly with the \o and \qecho meta- commands I can achieve exactly what I want to achieve. I will tinker with the syntax of these commands, having never used them before. But I believe that my trip to the documentation has answered my question. On Feb 27, 20

[pgadmin-support] Output to file

2010-02-27 Thread John Gage
Is there a way to have sequential SELECT queries output to the same file without having the second SELECT overwrite the first. Here is a sample: SELECT * FROM prof_texts_lines WHERE source_lines ~* '(enregistrement)' ORDER BY line_no ; SELECT * FROM prof_texts_lines WHERE source_lines ~* '