| From: | "Rader, David" <davidr(at)openscg(dot)com> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgresql-fdw |
| Date: | 2016-05-24 04:00:58 |
| Message-ID: | CAABt7R7K-EAzZVzT5rQM0n0ajWXRBxPFqZiSxcfotcd1CKByDA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, May 23, 2016 at 1:52 AM, aluka raju <alukaraju2894(at)gmail(dot)com> wrote:
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:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-05-24 12:50:52 | Re: FIRST_VALUE: need to group by argument? |
| Previous Message | Guyren Howe | 2016-05-24 03:48:26 | FIRST_VALUE: need to group by argument? |