dbPartKeyColEM: From a PostgreSQL Object Get Its Partition Key Definition

In AndreMikulec/econModel: Meaningful Social and Economic Data from ALFRED and elsewhere

Description

Of a PostgreSQL partition table, detect its partition key definition. If not a "partition table", an empty character vector is returned.

Usage

dbPartKeyColEM(connName, name, env, display = TRUE, exec = TRUE)

Arguments

connName	String. Default is "connEM". Contains the name of the variable that contains the name of the "connection" in the environment "env".
name	String. Name of the PostgreSQL object.
env	Environment. Default is the .Global environment. This is the environment to return the connection object "connEM".
display	Logical. Whether to display the query (defaults to TRUE).
exec	Logical. Whether to execute the query (defaults to TRUE).

Details

This is only designed to work on List partitioned tables with the non-expression key. Will work: "PARTITION BY LIST (c1)" is stored as "LIST (c1)". Will not work: "PARTITION BY LIST (CAST(c1) AS INTEGER)" is stored as "LIST (((c1)::integer))".

Value

vector of size 1 of the partition key definition.

AndreMikulec/econModel documentation built on June 30, 2021, 9:48 a.m.