I have data storage in flat files (structured and unstructured) . I want to run sql queries on that , so i am looking in to postgresql to this on the data that i have. I want to prepare a software for running sql queries for the data in files,so i am trying to have separate postgresql engine and write an wrappper for connecting the data that are in files.
Do these files change?
Do you have any idea how can we do ?
Have you considering uploading this data to PostgreSQL? It can store relational and JSOn data both.
I want use my data source as mongodb and connect through postgresql fdw. Is their any restrictions that the data present in mongodb to be structured or unstructured data?
For connecting to mongoDB you would need mongodb_fdw and not PostgreSQL fdw. I don't think they have any restrictions with respect to the data model.