Re: parsing pg_dump -l output - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: parsing pg_dump -l output
Date
Msg-id 20130816211232.GD8961@momjian.us
Whole thread Raw
In response to parsing pg_dump -l output  (Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.com>)
Responses Re: parsing pg_dump -l output
List pgsql-novice
On Fri, Aug 16, 2013 at 11:02:47AM +0200, Athanasios Kostopoulos wrote:
> Dear list,
> I am trying to understand the format of pg_dump -l 's output
> specifically let's examine the following line
>  16118; 1262 5499023 DATABASE - vourtsis postgres
>
> I understand that 16118 is an index value and the rest is a FYI information
> comment
> I am not sure in my example what 1262 and 5499023 are
> I understand that DATABASE indicates the type of what has been backed up
> vourtsis is the name of the object and postgres the owner, but I still have no
> idea about the first 2 numbers once the comment starts. I am trying to
> programmatically get (and subsequently sort) the sizes of what is contained
> within the backup.

I don't see any -l option for pg_dump.  Do you mean pg_restore -l?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


pgsql-novice by date:

Previous
From: "Birchall, Austen"
Date:
Subject: Re: sudo/access to the postres OS user
Next
From: Athanasios Kostopoulos
Date:
Subject: Re: parsing pg_dump -l output