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...

Syntax

PostgreSQL.Database(server as text, database as text, optional options as nullable record) as table.

About

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

Explanation

The record parameter should be defined in the format [option1 = value1, option2 = value2...] or [Query = "select ..."].