Re: pg_dumpall from a script

From: James Sewell <james(dot)sewell(at)lisasoft(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Raghu Ram <raghuchennuru(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dumpall from a script
Date: 2013-10-23 01:19:48
Message-ID: CANkGpBvrGcOAx=7XL0oDYb6PS+giNwwx9k9a95-wmYZh3JRMbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oh I missed that, I skimmed and thought it was the same as \set

Turns out it's not and it's exactly what I want!

Thanks!

James Sewell,
PostgreSQL Team Lead / Solutions Architect
______________________________________

Level 2, 50 Queen St, Melbourne VIC 3000

*P *(+61) 3 8370 8000 * **W* www.lisasoft.com *F *(+61) 3 8370 8099

On Wed, Oct 23, 2013 at 11:48 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On 10/22/2013 03:41 PM, James Sewell wrote:
>
>> Hello All,
>>
>> Thanks for the replies.Sorry I must have been a bit unclear, I realise I
>> *could* do this from the shell level, but can I do it from a PSQL
>> session somehow?
>>
>
> Lucas' \setenv method won't work for you?
>
>
>
> Cheers,
>>
>>
>> James Sewell,
>> PostgreSQL Team Lead / Solutions Architect
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

--

------------------------------
The contents of this email are confidential and may be subject to legal or
professional privilege and copyright. No representation is made that this
email is free of viruses or other defects. If you have received this
communication in error, you may not copy or distribute any part of it or
otherwise disclose its contents to anyone. Please advise the sender of your
incorrect receipt of this correspondence.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message BladeOfLight16 2013-10-23 02:09:06 Re: Bug? Function with side effects not evaluated in CTE
Previous Message Adrian Klaver 2013-10-23 00:48:34 Re: pg_dumpall from a script