Re: dat names generated by pg_dump

On 09/02/2018 07:07 PM, Ron wrote:
> On 09/02/2018 08:41 PM, Adrian Klaver wrote:
>> 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?
> 
> pg_dump, as described in the Subject.

Oops, missed that.

> 
>>
>> 2) What is their structure?
> 
> They're pg_dump files.

What is the full pg_dump command used?

> 
>>
>> 3) What do the numbers refer to?
> 
> That's what I'm asking the list.
> 
>>
>>>
>>> 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