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 how to use fdw on the data that i have.
You could use the file_fdw to "attach" the files as foreign tables. At least for the structured ones (CSV, delimited). As noted by other replies, this won't be efficient, but if you are doing analytics against all the data in the file or just scanning the data 1 time this works well: