Re: Scripting function definitions as SQL?

--SWTRyWv/ijrBap1m
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sun, May 11, 2008 at 06:12:40AM -0700, Postgres User wrote:
> Has anyone written a function that scripts out all the functions in a
> database as full SQL statements (Create Function.....)
>=20
> I found the below SQL will return all the fields needed to build a SQL
> statement, but it would take some work to combine the field values
> correctly to get the right format.  So does anyone know if the code
> has already been written by someone else?

Does pg_dump not do what you want?

Have a nice day,
--=20
Martijn van Oosterhout   <kleptog@[EMAIL PROTECTED]
>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while=20
> boarding. Thank you for flying nlogn airlines.

--SWTRyWv/ijrBap1m
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIJvlxIB7bNG8LQkwRAo25AJwIVt9ywCJxG237xFQTtGZWf+Nj8wCgkfQF
UdZSJu96iC4kD3EIqDnl4aw=
=jCfE
-----END PGP SIGNATURE-----

--SWTRyWv/ijrBap1m--