foreign table

How to access oracle database from postgres

This article explain From postgres, how can we  fetch oracle db data. For this we need to use foreign data wrapper and foreign table concepts. DEMO: 1.Create oracle client on postgres server:   ...

How to access csv files on file system using file_fdw in postgres

File_fdw is an extension which can be used to access flat files like csv in the server’s file system. Lets see the below DEMO: 1. Check whether file_fdw extension is available on server or not: ...