Date: Fri, 4 Jan 2013 11:46:40 -0700
From: Greg Schenzel <inittab@unixdev.net>
To: pgsql-admin@postgresql.org
Subject: Re: Mapping a Data File Back to a Table
Message-ID: <20130104184639.GA12422@graphite.accessaxis.com>
References: <20130104180933.GA21370@graphite.accessaxis.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="zhXaljGHf11kAtnf"
Content-Disposition: inline
In-Reply-To: <20130104180933.GA21370@graphite.accessaxis.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--zhXaljGHf11kAtnf
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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!
>=20


--zhXaljGHf11kAtnf
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAlDnI48ACgkQ2ua/BJvbazf4dACffme1NhqFDod1oSAyDM/h39fq
G+EAn2uO7ZLx3Q93q0doAmXsynLZatwg
=yGZl
-----END PGP SIGNATURE-----

--zhXaljGHf11kAtnf--