Skip site navigation (1) Skip section navigation (2)

Re: pg_dump -s dumps data?!

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump -s dumps data?!
Date: 2012-01-30 17:51:58
Message-ID: 4F26D8BE.5040704@gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On 01/30/2012 09:45 AM, hubert depesz lubaczewski wrote:
> On Mon, Jan 30, 2012 at 09:43:46AM -0800, Adrian Klaver wrote:
>> On 01/30/2012 09:23 AM, hubert depesz lubaczewski wrote:
>>
>>>
>>> I think I explained it in previous mails, and if not - sorry, but
>>> I clearly can't explain good enough - the point is that with the way how
>>> extensions now work, they are useless for providing way to create
>>> tables that will store data, in case you would ever want dump without
>>> this data.
>>
>> So in summary; if an extension creates a user table you want access
>> to that table(schema and data) via pg_dump, outside the extension
>> mechanism, without resorting to marking it as a configuration table.
>> Is that correct ?
>
> no.
> I want to be able to do both:
> 1. dump the data for the table
> 2. dump structure of other tables
> but not in the same file.

Actually that was what I was saying:)

"..via pg_dump, outside the extension mechanism.."

"..without resorting to marking it as a configuration table.."

Currently the extension mechanism is getting in the way of 1 & 2 above. 
What you want is for pg_dump to ignore the extension dependency process 
when you explicitly name a table and the operation on it.


>
> Best regards,
>
> depesz
>


-- 
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

pgsql-hackers by date

Next:From: hubert depesz lubaczewskiDate: 2012-01-30 17:53:45
Subject: Re: pg_dump -s dumps data?!
Previous:From: hubert depesz lubaczewskiDate: 2012-01-30 17:45:09
Subject: Re: pg_dump -s dumps data?!

pgsql-general by date

Next:From: hubert depesz lubaczewskiDate: 2012-01-30 17:53:45
Subject: Re: pg_dump -s dumps data?!
Previous:From: Scot KreienkampDate: 2012-01-30 17:48:56
Subject: list blocking queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group