Thread: (No Subject)

(No Subject)

From
"William Anthony Lim"
Date:
is it possible to dump within procedural language/SQL syntax? Using pg_dump from console is very confusing for some end
userwho don't have Linux skills. so I decide to create a function to do that, and they may call it from my
application.

Thanks

William


Need a new email address that people can remember
Check out the new EudoraMail at
http://www.eudoramail.com


Re: (No Subject)

From
Franco Bruno Borghesi
Date:
I remember reading somewhere that it was possible to execute system commands from plperl...  don't know if it's the
bestway, but you could do an exec of pg_dump from inside a plperl procedure.<br /><br /> On Fri, 2004-06-11 at 01:36,
WilliamAnthony Lim wrote: <blockquote type="CITE"><pre><font color="#737373"><i>is it possible to dump within
procedurallanguage/SQL syntax? Using pg_dump from console is very confusing for some end user who don't have Linux
skills.so I decide to create a function to do that, and they may call it from my application. 

Thanks

William


Need a new email address that people can remember
Check out the new EudoraMail at</i></font>
<a href="http://www.eudoramail.com"><u>http://www.eudoramail.com</u></a>
<font color="#737373">
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your     joining column's datatypes do not match
</font></pre></blockquote>

pg_dump inside function (was: Re: (No Subject))

From
Martin Knipper
Date:
Please provide a subject for futher mailings to this list.

Am 11.06.2004 06:36 schrieb William Anthony Lim:
> is it possible to dump within procedural language/SQL syntax?
> Using pg_dump from console is very confusing for some end user
> who don't have Linux skills. so I decide to create a function to
> do that, and they may call it from my application.
> 

Why don't you use a system call e.g. system("pg_dump ...") inside
your application. It should be available in the programming language
you use to write your application.

Greetings,
Martin