Thread: Write in file from postgres
-------------------------------------------------- From: "Kevin Martins" <martins506@hotmail.com> Sent: Thursday, April 10, 2008 12:03 AM To: <pgsql-general@postgresql.org> Subject: Re: [GENERAL] pain of postgres upgrade with extensions > > Hello everybody, > First off all I am new in postgres but allready got some questions. It's > possible to wirte in a file from postgres? > Kevin Martins > -------------------------------------------------- > From: "Dave Potts" <dave.potts@pinan.co.uk> > Sent: Wednesday, March 12, 2008 8:46 PM > To: <pgsql-general@postgresql.org> > Subject: Re: [GENERAL] pain of postgres upgrade with extensions > >> Greg Sabino Mullane wrote: >>> -----BEGIN PGP SIGNED MESSAGE----- >>> Hash: RIPEMD160 >>> >>> >>> >>>> - dump version N database >>>> - create empty version N+1 database >>>> - install N+1's version of each needed contrib module into new database >>>> - restore dump, ignoring "object already exists" errors >>>> >>>> There is a TODO to figure out some cleaner way of handling this sort >>>> of thing ... >>>> >>> >>> I think I smell a GSOC project.... >>> >> >> I think there is a slight misunderstanding here, I was refering to >> extensions items such as postgis, plr, pgperl, etc. These have a slight >> different foot print to the projects in the contrib directory. >> >> Dave >>> - -- >>> Greg Sabino Mullane greg@turnstep.com >>> End Point Corporation >>> PGP Key: 0x14964AC8 200803121533 >>> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 >>> -----BEGIN PGP SIGNATURE----- >>> >>> iEYEAREDAAYFAkfYMBMACgkQvJuQZxSWSsjmmwCg1JvB0G2py5jSbJdSZpWR8YyV >>> D4YAoLg2ZinEEGoNEU7S2mcL3bqhmNIh >>> =7pvA >>> -----END PGP SIGNATURE----- >>> >>> >>> >>> >> >> > > > >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >>
Kevin Martins wrote: > Hello everybody, > First off all I am new in postgres but allready got some questions. It's > possible to wirte in a file from postgres? First off, if you write to a mailing list you should first learn how to write an e-mail. Really. Core PostgreSQL does not have such a function; you'd have to write it yourself in C. There is, however, a function "pg_catalog.pg_file_write(text, text, bool)" in the "adminpack" contrib module that you could (ab)use for your purposes. This function may only be used by a superuser, and it would not be a good idea to have it otherwise. Yours, Laurenz Albe