Write in file from postgres

--------------------------------------------------
From: "Kevin Martins" <martins506(at)hotmail(dot)com>
Sent: Thursday, April 10, 2008 12:03 AM
To: <pgsql-general(at)postgresql(dot)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(dot)potts(at)pinan(dot)co(dot)uk>
> Sent: Wednesday, March 12, 2008 8:46 PM
> To: <pgsql-general(at)postgresql(dot)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(at)turnstep(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>