Trigger - create folder/folder structure on new row

Hi is there any way to create a folder or folder structure to a specific location on a network drive with postgresql trigger, when a new row added?.

the new row would contains the new folder names in different fields.

Answers


One solution for that is to use the (untrusted) procedure language pl/perlu for your trigger, where you can use standard perl commandos for filesystem manipulation. You will have to take care about correct access rights for creating the directories, however.

CREATE LANGUAGE plperlu;

CREATE FUNCTION perlfunc(text) RETURNS integer AS $$
      mkdir($_[0]);
$$ LANGUAGE plperlu

Note that the standard pl/perl, as a trusted language, will catch such attempts and reject access to the system environment, so indeed plperlu must be used.


Need Your Help

Cocoa WebView with private browsing - WebPreferences not been applied

objective-c macos cocoa webview webkit

I am trying to enable Private Browsing in a Cocoa WebView on a Mac App, however my WebPreferences are not been applied for some reason. Does anyone have any ideas? The WebView doesn't end up using

Display MySql Data Using Div

php html mysql twitter-bootstrap

How to display images from mysql database, specifically two images in a row. I've read many articles in stack overflow, all of them discussed using the table tag. But I couldn't find any article us...