Cc pg-list
Pls avoiding reaching out to members via list. I may not know something which someone else in the list may know.
On Mon, 23 May 2016, 1:22 p.m. aluka raju, <alukaraju2894@xxxxxxxxx> wrote:
Hello,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.
Thanks,On Mon, May 23, 2016 at 10:37 AM, Sameer Kumar <sameer.kumar@xxxxxxxxxx> wrote:On Mon, 23 May 2016, 1:03 p.m. aluka raju, <alukaraju2894@xxxxxxxxx> wrote:Hello,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.BTW, why do you want to do that?----Best RegardsSameer Kumar | DB Solution ArchitectASHNIK PTE. LTD.101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com