Foreign tables with JSON data have the following columns:
- Location column
- Payload column with a JSON data type
You can perform the following types of operations (and others) on foreign tables with JSON data, see Examples.