PostgreSQL.Database
This function retrieves a list of SQL tables and views available in a PostgreSQL database on a specified server within a database instance. The port for the server can be optionally specified by addin...
PostgreSQL.Database(server as text, database as text, optional options as nullable record) as table.
This function retrieves a list of SQL tables and views available in a PostgreSQL database on a specified server within a database instance. The port for the server can be optionally specified by adding a colon after the server address.
An optional parameter called options can be provided to customize the behavior of the function:
- CreateNavigationProperties: Determines whether navigation properties should be generated for the returned values, default is true.
- NavigationPropertyNameGenerator: A function used to generate names for navigation properties.
- Query: A native SQL query that retrieves data. If multiple result sets are produced, only the first will be returned.
- CommandTimeout: Controls the duration before a server-side query is canceled, default is ten minutes.
- ConnectionTimeout: Determines how long to wait before abandoning a connection attempt to the server, default value depends on the driver being used.
- HierarchicalNavigation: Sets whether tables should be grouped by schema names, defa