hello oh-more-knowledgable-than-me postgres folks!
i'd like to run a select statement tonight after everyone is gone, and i
don't feel like coming back in to do it (last person gone at 11pm). i need
the output saved to a file, if possible. how can i do it from the bash
prompt?? (linux rh 5.
Sure, psql has options for input query and output:
psql database output.
> hello oh-more-knowledgable-than-me postgres folks!
>
> i'd like to run a select statement tonight after everyone is gone, and i
> don't feel like coming back in to do it (last person gone at 11pm). i need
> t
> On Wed, 4 Aug 1999, Bruce Momjian wrote:
>
> > Please send a reproducable sample, with CREATE TABLE, INSERT, etc.
>
> My table is rather large so here's one small sample. This one doesn't
> crash, but it hangs on DELETE using up 100% CPU. This one is tested on
> FreeBSD 3.2-STABLE.
>
> CREATE
see if this looks right to you (to be put in a cron. . .)
su pgsqluser -c "psql database -c 'select fields from tables where conditions;'
>outputfilename"
:-)or:-( ??
thanks! jt
-Original Message-
From: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
Sent: Monday, September 27, 1
