The paths table is used by the GPMDB installations to store information on result file locations. It is not updated during the daily update process, nor can users access it. This table is referenced by the result table.
Columns:
- pathid: the unique identifier for a specific path.
- protocol: the protocol to use to fetch the file in question. Theoretically, it would be possible to have an installation of GPMDB where some files were stored remotely and retrieved via ftp instead of http.
- server: the name of the server; used in conjunction with the protocol to fetch the requested file.
- localpath: the local path used by the file system.
- relpath: the relative path to the file, to be used in conjunction with the protocol and server.