query_field_type: Get Field Datatypes

In patelm9/pg13: pg13 Package

Description

Get Field Datatypes

Usage

query_field_type(
  conn,
  conn_fun,
  table,
  sql_statement,
  verbose = TRUE,
  render_sql = TRUE,
  render_only = FALSE,
  ...
)

Examples

library(pg13)
create_test_schema <-
        function(conn) {

                if (!schema_exists(conn = conn,
                                   schema = "test_schema")) {

                        cli::cli_rule("Create 'test_schema' Schema")

                        create_schema(conn = conn,
                                      schema = "test_schema")

                }
        }


conn <- local_connect(dbname = "pg13_test")
create_test_schema(conn = conn)
write_table(conn = conn,
            schema = "test_schema",
            table_name = "test_table",
            drop_existing = TRUE,
            data = data.frame(A = 1:3, B = letters[1:3]))

query_field_type(conn = conn,
               table = "test_table")



drop_table(conn = conn,
           schema = "test_schema",
           table = "test_table")

drop_schema(conn = conn,
            schema = "test_schema",
            cascade = TRUE)

dc(conn = conn)

patelm9/pg13 documentation built on Dec. 26, 2021, 8:17 p.m.