[SQL] postgres on the comman line

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

[SQL] how to replace

Hello, I initially thought this is simple.. I want to relpace a character to nothing. Eg. relace "B" to "" -> ABCD to ACD. All me approches vaild but I am sure that I have seen it already and think it was not tricky.. Can someone please help me ? Thanks a lot Michael -