Creating a foreign table
The last step in initializing foreign data access is the creation of the foreign table itself. While doing so, we are limited to specifying column names, types, default values, and whether or not each column is nullable. This table skeleton helps the PostgreSQL query planner interact with the remote data as efficiently as possible.
In this recipe, we will create a foreign table and make it ready for use by our mapped user.
Getting ready
As we will be using a foreign server and a user mapping in this recipe, please follow all the previous recipes before proceeding.
How to do it...
For this recipe, we will perform all actions on the pg-report PostgreSQL server in the pgbench database. Follow these steps to create a table in ...
Get PostgreSQL 9 High Availability Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
