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 on foreign tables with JSON data:
- Display keys, see Example: Displaying Keys in a Foreign Table Containing JSON Data.
- Query data, see Example: Querying a Foreign Table Containing JSON Data.