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@xxxxxxxxxxx
