Hello,
How can open a unix shell from a PLPGSQL function / trigger?
I would like to send an email from a postgres database, and also send some unix commands to the server, through the database...
Thanks
-------------------------
Philippe Lang
Attik System http://www.attiksystem.ch
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend 3 5070
Why not create a cron script which connects to the database and queries
your tables (using psql). Have it generate an output (shell) script which
your original script then calls.
Unfortunately I know how to do this with Oracle, but not postgres *yet*,
but I suspect that in principle this idea will work.
Maybe someone else has an example, or a better suggestion.
John Sidney-Woollett
Philippe Lang said: Hello,
How can open a unix shell from a PLPGSQL function / trigger?
I would like to send an email from a postgres database, and also send some unix commands to the server, through the database...
Thanks
------------------------- Philippe Lang Attik System http://www.attiksystem.ch
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
Hello
If you require only send mail, try pgsendmail. http://sourceforge.net/project/showf...group_id=35804.
You can use plsh too. http://developer.postgresql.org/~petere/pgplsh/
regards
Pavel Stehule
On Tue, 9 Dec 2003, Philippe Lang wrote: Hello,
How can open a unix shell from a PLPGSQL function / trigger?
I would like to send an email from a postgres database, and also send some unix commands to the server, through the database...
Thanks
------------------------- Philippe Lang Attik System http://www.attiksystem.ch
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
Philippe Lang wrote: Hello,
How can open a unix shell from a PLPGSQL function / trigger?
I would like to send an email from a postgres database, and also send some unix commands to the server, through the database... http://archives.postgresql.org/pgsql...1/msg00098.php
HTH
Shridhar
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Lu |
last post by:
Hi,
I have a redhat 9 linux machine running apache 2.0.47, mysql 4.0.15,
and php 4.3.4. I have been puzzled by this mail() problem for quite a
while, could someone please give me some hint on this?
I configured sendmail with a relay so that all outgoing mails go
through our organization's exchange mail server:
DSexchange.domain.com. The php.ini file specified the path to
sendmail: "sendmail_path= /usr/sbin/sendmail -t -i".
|
by: Bill |
last post by:
I used to be able to run the following ASP code on our corp machine (W2K
Server Edition and IIS-5)
and successfully send a net-msg to anyone on our intranet.
Last week it stopped working... and I'm not sure what changed.
(I had applied ALL the W2K update patches... but... I'm not sure if the
problem started before or after that.)
Did any recent W2K patches change the way createObject, wScript.shell, or
"NET SEND" works?
|
by: Kyle |
last post by:
To any who chose to provide an answer, or even any suggestions to this
problem, I thank you greatly in advance. +200 pts. for any valid
solutions.
I am currently in the process of converting a website from an existing
web host to our servers. This website used the WScript.Shell command
to execute a series of Java commands that would send an encrypted
email.
I ran these commands directly on the server and they execute properly,
|
by: CJM |
last post by:
I have a query which produces different results in the Access query builder
and in an ASP page (via ADO)
An example of the query is:
----------------------------------------------------------
Select 'Ranked' as Source, H.HotelName, H.TelNo, H.URL, H.Location,
H.HotelID, Rank
from (Hotels H Inner Join PrefHotels P on H.HotelID = P.HotelID)
Inner Join Locations L on P.LocID = L.LocID
where Rank is not null and Rank > 0 and L.LocID=2
|
by: Scott Ribe |
last post by:
I've got a problem which I think may be a bug in Postgres, but I wonder if
I'm missing something. Two tables, A & B have foreign key relations to each
other. A 3rd table C, inherits from A. A stored procedure updates a row in
C, adds a row each in B & C. I get an integrity violation. All the foreign
keys are deferrable, and the stored procedure is called from within a
transaction with constraints deferred. (And the foreign keys do refer to...
| |
by: moondaddy |
last post by:
I need to start an ms access 2003 app from a vb.net winforms app and didn't
want to load all the interop stuff for office into the .net project. I
thought that using the shell cmd would be a nice clean way to get it
started. However, when I call the shell cmd, I get a "File Not Found"
error. here's my code:
Dim ClientPath As String = Directory.GetCurrentDirectory & "\" &...
|
by: Bill Moran |
last post by:
I've got a bit of a strange problem that's causing me some MAJOR
headaches.
I'm developing the server-side of a large database application in
PostgreSQL. This consists of a C daemon, and a LOT of stored
functions in the database.
I'm developing this in conjunction with another company, who is
developing the the client side. I've got a 7.4 server that I'm
developing on, and once a day I push my changes up to a common
|
by: ttamilvanan81 |
last post by:
Hai,
I need to send and receive Email's using VB and Ms-Access. Am using the following code. If i run this code, i has the error message as,
Compile Error
User-defined type not defined in the code for New clsSendMail
Private Sub Command0_Click()
Set poSendMail = New clsSendMail
poSendMail.UseAuthentication = True
poSendMail.UsePopAuthentication = True
|
by: Brit |
last post by:
I have an ASP file that retrieves names from an Access database for 4 different categories of membership, which the visitor to the page selects (corporate, institutional, regular, or student). The DNS name is "cati", the names are specified in the "Last_names" field, and the categories are in the "categories" field.
l want the results sorted in alphabetic order by last name. However, the results appear to be in a totally random,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |