Thread: (No Subject)
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
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>
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