Re: dat names generated by pg_dump

On 09/02/2018 05:40 PM, Ron wrote:
> Hi,
> 
> I can associate these dat names with their source tables through a bunch 
> of bash and vim manual operations, but I was wondering if there's any 
> automated method (maybe some SQL query of some catalog table; pg_class 
> didn't seem to have the relevant data) of making the association.

Some background would be helpful:

1) What is producing the *.dat files?

2) What is their structure?

3) What do the numbers refer to?

> 
> If relevant, the source database is v8.4, but the backup was done by 9.6 
> on a separate server.
> 
> $ ls -1 CDSLBXW/*dat | head
> CDSLBXW/8412.dat
> CDSLBXW/8414.dat
> CDSLBXW/8416.dat
> CDSLBXW/8418.dat
> CDSLBXW/8420.dat
> CDSLBXW/8422.dat
> CDSLBXW/8423.dat
> CDSLBXW/8425.dat
> CDSLBXW/8427.dat
> CDSLBXW/8428.dat
> 
> Thanks
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com