X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 5A5D0D1B1F7
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 11 Jun 2004 11:02:44 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 34212-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 11 Jun 2004 14:02:39 +0000 (GMT)
Received: from lucifer.oficina (unknown [200.68.121.201])
	by svr1.postgresql.org (Postfix) with ESMTP id DF7DDD1B1CB
	for <pgsql-sql@postgresql.org>; Fri, 11 Jun 2004 11:02:33 -0300 (ADT)
Received: from localhost (localhost.akyasociados.com.ar [127.0.0.1])
	by lucifer.oficina (8.12.10/8.12.10) with ESMTP id i5BE2bBF061484;
	Fri, 11 Jun 2004 11:02:37 -0300 (ART)
	(envelope-from franco@akyasociados.com.ar)
Received: from lucifer.oficina ([127.0.0.1])
	by localhost (lucifer.oficina [127.0.0.1]) (amavisd-new, port 10024)
	with LMTP id 60933-02; Fri, 11 Jun 2004 11:02:36 -0300 (ART)
Received: from [192.168.1.198] (taz.oficina [192.168.1.198])
	(authenticated bits=0)
	by lucifer.oficina (8.12.10/8.12.10) with ESMTP id i5BE2Z2C061478;
	Fri, 11 Jun 2004 11:02:35 -0300 (ART)
	(envelope-from franco@akyasociados.com.ar)
Subject: Re: (No Subject)
From: Franco Bruno Borghesi <franco@akyasociados.com.ar>
To: wei.liang@eudoramail.com
Cc: pgsql-sql@postgresql.org
In-Reply-To: <CPPCNALNBDAIECAA@whowhere.com>
References: <CPPCNALNBDAIECAA@whowhere.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-9IGY7+N0AK5GhmTEvCHk"
Organization: AK y Asociados S.R.L.
Message-Id: <1086962554.32629.2.camel@taz.oficina>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 
Date: Fri, 11 Jun 2004 11:02:35 -0300
X-Virus-Scanned: by amavisd-new at akyasociados.com.ar
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0
	tests=HTML_FONTCOLOR_UNSAFE, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200406/98
X-Sequence-Number: 18043

--=-9IGY7+N0AK5GhmTEvCHk
Content-Type: multipart/alternative; boundary="=-r4Fj0gxxtW2P/IjWb8TQ"

--=-r4Fj0gxxtW2P/IjWb8TQ
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

I remember reading somewhere that it was possible to execute system
commands from plperl...  don't know if it's the best way, but you could
do an exec of pg_dump from inside a plperl procedure.

On Fri, 2004-06-11 at 01:36, William Anthony Lim wrote:

> is it possible to dump within procedural language/SQL syntax? Using pg_du=
mp from console is very confusing for some end user who don't have Linux sk=
ills. so I decide to create a function to do that, and they may call it fro=
m my application.
>=20
> Thanks
>=20
> William
>=20
>=20
> Need a new email address that people can remember
> Check out the new EudoraMail at
> http://www.eudoramail.com
>=20
> ---------------------------(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
>=20

--=-r4Fj0gxxtW2P/IjWb8TQ
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; CHARSET=3DUTF-8">
  <META NAME=3D"GENERATOR" CONTENT=3D"GtkHTML/3.0.10">
</HEAD>
<BODY>
I remember reading somewhere that it was possible to execute system command=
s from plperl...&nbsp; don't know if it's the best way, but you could do an=
 exec of pg_dump from inside a plperl procedure.<BR>
<BR>
On Fri, 2004-06-11 at 01:36, William Anthony Lim wrote:
<BLOCKQUOTE TYPE=3DCITE>
<PRE><FONT COLOR=3D"#737373"><I>is it possible to dump within procedural la=
nguage/SQL syntax? Using pg_dump from console is very confusing for some en=
d 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</FONT>
<A HREF=3D"http://www.eudoramail.com"><U>http://www.eudoramail.com</U></A>
<FONT COLOR=3D"#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
</I></FONT></PRE>
</BLOCKQUOTE>
</BODY>
</HTML>

--=-r4Fj0gxxtW2P/IjWb8TQ--

--=-9IGY7+N0AK5GhmTEvCHk
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQBAybt621dVnhLsBV0RAlM4AJ9pBt5trw8S7BTrj73ILHJGBY4ObwCfd5do
02OLyOo7fu6zh4auqSWKLiA=
=3n1e
-----END PGP SIGNATURE-----

--=-9IGY7+N0AK5GhmTEvCHk--