We have a postgresql box housing an old database that we are asking some db consultants to migrate. They are asking about any meta data. I am digging through bash looking at .sh files and such. Could anyone point me in a direction that would lead to this? It is a basically housing pdfs that you can find in the file system just fine, in directories number 0 through 9 in depth. We are trying to get this migrated to MS SQL 2008. I hope someone can help.

I used postgresql commands in bash to dig out some information, but do not have the root for the db.

One thing I got is that it is Version: 8.1.19, but I read that is only the client version with the command/access I had.

Thank you.

look at the information_schema