| From: | "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com> |
|---|---|
| To: | "Russ Schneider" <russ(at)sugapablo(dot)com> |
| Cc: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: piping output to file |
| Date: | 2004-02-09 18:56:21 |
| Message-ID: | 64AE3D5B518E3648ACC823FBCB0B737502767A08@sr002-2kexc.ateb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
also,
$ psql -c "select whatever_you_want from table_name" > outfile
reid
> -----Original Message-----
> From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
> Sent: Monday, February 09, 2004 12:17 PM
> To: Russ Schneider
> Cc: pgsql-general
> Subject: Re: [GENERAL] piping output to file
>
>
> On Sun, 8 Feb 2004, Russ Schneider wrote:
>
> > Is there an easy way to pipe a select statement's output to a file?
>
> In psql you can use \o [filename] to direct query output to a file.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Lester | 2004-02-09 19:04:12 | Re: Increasing Max Connections Mac OS 10.3 |
| Previous Message | Hilary Cotter | 2004-02-09 18:43:12 | odbc problems |