Re: [ADMIN] Add a new disk to data directory

2005-07-28 Thread Hans Peter Wiedau
On Wed, Jul 27, 2005 at 06:57:45PM +0200, Michelle Konzack wrote: > I think, using LVM on a database is very risky. Why? Hans Peter -- /Quelltext AG -- Professional Software Services // // Hans Peter Wiedau <[EMAIL PROTECTED]>, CEO // // Ostenhellweg 31, 44135

Re: [ADMIN] Destroying all exisitng tables in database

2005-04-19 Thread Hans Peter Wiedau
rop.tablename; END LOOP; RETURN numberoftables; END; ' LANGUAGE plpgsql; - snip-snap - You execute it by "select dropit();" on the psql commandline. But be warned, it will drop _all_ tables in the used schema. cu, Hans Peter -- /Quelltext AG -- Professional

Re: [ADMIN] How to use psql -c?

2003-12-30 Thread Hans Peter Wiedau
this? The bash manual page says: A single quote may not occur between single quotes, even when preceded by a backslash. So, try this one: su - postgres -c "psql -c \"DELETE FROM prg_dates_members WHERE confirm = 'f'\" comfire" cu, Hans Peter -- /Qu