[GENERAL] DROP TABLE wildcard

[Andy Koch]

Is it possible to drop multiple tables with SQL on the system tables:

I tried this:

DROP TABLE from pg_tables where tablename LIKE 'table_num_%';

Which for whatever reason would delete 0 items despite it should have 
matched on several.

Of course I'm not even sure pg_tables would be the smart place to make the 
delete from?

Thanks.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Cannot build PL/Perl ...

[Andy Koch]

At 09:59 PM 5/2/2001 +0200, you wrote:
Cannot build PL/Perl because libperl is not a shared library.
I'v got this error when I tried to compile PL/Perl.
I have SuSE Linux 7.0 , have I get a libperl.so library , and put it in
/usr /lib ...

Thanks for any help
Adam

Hi Adam, I went through getting pl/perl working not too long ago - this 
part of the docs talks about what you need to do.

http://www.ca.postgresql.org/users-lounge/docs/7.1/programmer/plperl.html

By the way, if you intend to use perl functions with triggers - you should 
be warned now that you can't - its not supported with 7.0. Although I don't 
know about 7.1.

Andy.


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])