Re: [SQL] postgres on the comman line

2005-09-22 Thread Achilleus Mantzios
O "Michael Hφller" έγραψε στις Sep 22, 2005 : > > > Hello, > > I like to automate a daily check and like to run select statement via > cron but this seems to be more tricky than I thought > > I tried the following: > su postgres -c "select count(*) from TABLE where xx;" Firstoff, 'sel

Re: [SQL] postgres on the comman line

2005-09-22 Thread A. Kretschmer
am 22.09.2005, um 15:55:53 +0200 mailte "Michael Höller" folgendes: > > > Hello, > > I like to automate a daily check and like to run select statement via > cron but this seems to be more tricky than I thought > > I tried the following: > su postgres -c "select count(*) from TABLE where xx

Re: [SQL] postgres on the comman line

2005-09-22 Thread Thomas Pundt
Hi Michael, On Thursday 22 September 2005 15:55, Michael Höller wrote: | I like to automate a daily check and like to run select statement via | cron but this seems to be more tricky than I thought | | I tried the following: | su postgres -c "select count(*) from TABLE where xx;" you mean

[SQL] postgres on the comman line

2005-09-22 Thread Michael Höller
Hello, I like to automate a daily check and like to run select statement via cron but this seems to be more tricky than I thought I tried the following: su postgres -c "select count(*) from TABLE where xx;" I have the probelm that I am allways asked for the password - I did not find a