Get case-sensitive table name on server — get_server_tablename • amstel

Since some DBMS are case-sensitive use the names of the tables currently stored in the database to prevent creating new ones with a different case

Usage

get_server_tablename(tablename, conn)

Arguments

tablename: Name of the table to check
conn: DatabaseConnector Connection object

Value

String server table name

Examples

conn <- connect("cdm")
#> Connecting using PostgreSQL driver
#> Executing SQL took 0.00306 secs
table <- get_server_tablename("PROCEDURE_OCCURRENCE", conn)
table
#> [1] "procedure_occurrence"