Write in file from postgres

Started by Kevin Martinsabout 18 years ago2 messagesgeneral
Jump to latest
#1Kevin Martins
martins506@hotmail.com

--------------------------------------------------
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

Show quoted text

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

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Kevin Martins (#1)
Re: Write in file from postgres

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