dbListInheritEM: Of a PostgreSQL Object, Get Inherited or Inherit_From Objects

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

Description

Of the PostgreSQL object, get the child/parent objects (if any) with the schema.

Usage

dbListInheritEM(
  connName,
  name,
  side = "parent",
  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. Required. Name of the object.
side	String. View from the "parent side. Default is "parent". Alternately, the view from the "child side" is the value "child".
env	Environment. Default is the .Global environment.
display	Logical. Whether to display the query (defaults to TRUE).
exec	Logical. Whether to execute the query (defaults to TRUE).

Details

Of column results named *_RELKIND, see the table pg_namespace column relkind. These values are the following: r = ordinary table, i = index, S = sequence, t = TOAST table, v = view, m = materialized view, c = composite type, f = foreign table, p = partitioned table, I = partitioned index.

Of column results named like '_PART_KEY_DEF' and '_PART_BOUND', these are the partition object key (LISTs, RANGEs, and HASHs) and the partitions (child objects) bounds (FOR VALUES . . .) (of the partition object). See the references.

Value

Dataframe of inherited or inherit_from "objects" (if any) (with schema name).

References

Get number of partitions in PostgreSQL database https://stackoverflow.com/questions/8634144/get-number-of-partitions-in-postgresql-database

How to identify the ranges over which a postgres table was partitioned? https://dba.stackexchange.com/questions/221277/how-to-identify-the-ranges-over-which-a-postgres-table-was-partitioned

Examples

## Not run: 
dbListInheritEM(name = "sample")

## End(Not run)

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