From: Greg Schenzel <inittab@unixdev.net>
To: pgsql-admin@postgresql.org
Subject: Re: Mapping a Data File Back to a Table
Date: Fri, 4 Jan 2013 11:46:40 -0700
Message-ID: <20130104184639.GA12422@graphite.accessaxis.com> (raw)
In-Reply-To: <20130104180933.GA21370@graphite.accessaxis.com>
References: <20130104180933.GA21370@graphite.accessaxis.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
It was stored in pg_largeobject based on the OID.
On Fri, Jan 04, 2013 at 11:09:33AM -0700, Greg Schenzel wrote:
> So I've been digging through a database on an embedded device for two
> days trying to figure out which table some data is stored in. There
> are litterally 1000 tables in the database and I haven't come across
> the right one(s) yet. I know that the data I'm looking for is stored
> in /var/lib/pgsql/data/base/16384/2613 from strings and grep. Is there
> any way to map this back to a table or group of tables? Any insight
> would be greatly appreciated!
>
Attachments:
signature.asc (application/pgp-signature, 197B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: inittab@unixdev.net
Subject: Re: Mapping a Data File Back to a Table
In-Reply-To: <20130104184639.GA12422@graphite.accessaxis.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox