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
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
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