Man pages for patelm9/pg13
pg13 Package
| affix_date | Affix the System Date to a String |
| append_date | Append Current Date to a String |
| appendDate | Append Current Date to a String |
| append_table | Append a Table |
| appendTable | Append a Table |
| append_table2 | Append to am Existing Table |
| appendTable2 | Append to am Existing Table |
| args | Arguments |
| base_args | Arguments |
| build_join_query | Build a Query for a Join |
| buildJoinQuery | Build a JOIN SQL Query |
| build_query | Build a Simple SQL Query |
| buildQuery | Build a SQL Query |
| build_query_like | Build a Like Query |
| buildQueryLike | Writes a Like SQL Query |
| build_query_regex | Build a Regex Query |
| build_query_string | Build a Query the Loops Over String |
| buildQueryString | Writes a SQL Query Loop |
| cache | Cache a Resultset |
| cache_join | Cache a Resultset from a Join |
| cacheJoin | Cache a Resultset from a Join |
| cache_query | Cache a Query Resultset |
| cacheQuery | Cache a Query Resultset |
| cat_plr_example | Print an Example of a Postgres Function using PLR |
| cat_sql | Concatenate SQL statement |
| cat_sql_chunk | Concatenate a SQL Chunk |
| check_conn | Check a Connection Object |
| check_conn_status | Check Connection Status |
| check_conn_type | Check if a Connection is JDBC |
| check_data_rows | Check that the data has rows |
| check_field_name | Check a field name |
| check_field_names | Check a multiple field names |
| check_outflow | Check Outgoing Data |
| check_output_rows | Check that the outgoing data has rows |
| check_rows | Check that the incoming data has rows |
| check_source_rows | Check that the table has any rows |
| check_table_name | Check Table Name |
| clear_cache | Clear a Cache |
| clearCache | Clear a Cache |
| close_conn | Close Connections in 'pg13_connection_env' |
| concat_where_constructs | Concatenate 2 WHERE constructs |
| concatWhereConstructs | Concatenate 2 WHERE constructs |
| conn_db | Connect to a Postgres Database |
| connDB | Connect to a Postgres Database |
| connect | Connect to a Postgres Database |
| connect_ff | Connection Function Factory |
| connection | Postgres Connection |
| construct_base | Construct a base SQL query |
| constructBase | Construct a base SQL query |
| construct_in | Render y in "WHERE x IN (y)" |
| constructIn | Render y in "WHERE x IN (y)" |
| constructJoin | Construct a join part of a SQL Statement |
| construct_limit | Construct LIMIT |
| constructLimit | Construct LIMIT |
| construct_random | Construct ORDER BY RANDOM() |
| constructRandom | Construct ORDER BY RANDOM() |
| construct_schema_table_name | Construct schemaTableName |
| constructSchemaTableName | Construct schemaTableName |
| construct_where_in | Render x in "WHERE x IN y" |
| constructWhereIn | Render x in "WHERE x IN y" |
| construct_where_like | Render "WHERE x LIKE y" |
| constructWhereLike | Render "WHERE x LIKE y" |
| construct_where_lower_in | Render "WHERE lowercase x IN y" Component |
| constructWhereLowerIn | Render "WHERE lowercase x IN y" Component |
| construct_where_lower_like | Render WHERE lowercase x LIKE y |
| constructWhereLowerLike | Render WHERE lowercase x LIKE y |
| construct_where_lower_not_in | Render "WHERE lowercase x NOT IN y" |
| constructWhereLowerNotIn | Render "WHERE lowercase x NOT IN y" |
| construct_where_not_in | Render "WHERE x NOT IN y" |
| constructWhereNotIn | Render "WHERE x NOT IN y" |
| count_constraint_types | FUNCTION_TITLE |
| create_db | Create a New Database |
| createDB | Create a New Database |
| create_log | Create a Log Table |
| create_schema | Create a Schema |
| createSchema | Create a Schema |
| create_table | Create a Table |
| createTable | Draft SQL to Create a Table |
| create_table_from_df | Create a Table with a Dataframe |
| createTableFromDF | Create a Table with a Dataframe |
| db_exists | Does a database exist? |
| dc | Disconnect a Connection |
| dc0 | Disconnect a Connection |
| depivot_table | Depivot a Table |
| draft_base | Construct a base SQL query |
| draftBase | Construct a base SQL query |
| draft_create_table | Draft SQL to Create a Table |
| draft_create_table_from_df | Draft the SQL to Create Table |
| draftCreateTableFromDF | Draft the SQL to Create Table |
| draft_in | Render y in "WHERE x IN (y)" |
| draftIn | Render y in "WHERE x IN (y)" |
| draft_join | Construct a join part of a SQL Statement |
| draftJoin | Construct a join part of a SQL Statement |
| draft_join1 | Draft a First Degree Join |
| draft_join_on | Draft a Join On |
| draft_limit | Construct LIMIT |
| draftLimit | Construct LIMIT |
| draft_random | Construct ORDER BY RANDOM() |
| draftRandom | Construct ORDER BY RANDOM() |
| draft_table_path | Construct schemaTableName |
| draftTablePath | Construct schemaTableName |
| draft_where_in | Render x in "WHERE x IN y" |
| draftWhereIn | Render x in "WHERE x IN y" |
| draft_where_like | Render "WHERE x LIKE y" |
| draftWhereLike | Render "WHERE x LIKE y" |
| draft_where_lower_in | Render "WHERE lowercase x IN y" Component |
| draftWhereLowerIn | Render "WHERE lowercase x IN y" Component |
| draft_where_lower_like | Render WHERE lowercase x LIKE y |
| draftWhereLowerLike | Render WHERE lowercase x LIKE y |
| draft_where_lower_not_in | Render "WHERE lowercase x NOT IN y" |
| draftWhereLowerNotIn | Render "WHERE lowercase x NOT IN y" |
| draft_where_not_in | Render "WHERE x NOT IN y" |
| draftWhereNotIn | Render "WHERE x NOT IN y" |
| drop_all_staging_tables | Drop V Tables |
| drop_cascade | Drop a Postgres schema |
| dropCascade | Drop a Postgres schema |
| drop_db | Drop a Database |
| drop_if_exists | Drop a Postgres schema |
| dropIfExists | Drop a Postgres schema |
| drop_schema | Drop a Postgres schema |
| dropSchema | Drop a Postgres schema |
| drop_table | Drop a Table |
| dropTable | Drop a Table |
| drop_table_batch | Drop a Batch of Tables using Regex |
| e_creds_ff | Query Function Factory |
| execute | Execute SQL |
| execute_fun_ff | Execute Function Factory using Connection Expression |
| execute_n | Query with more than 1 SQL Statements |
| field_exists | Does a field exist? |
| file_query | Send Query to any Postgres connection |
| fileQuery | Send Query to any Postgres connection |
| file_send | Send Query to any Postgres connection |
| fileSend | Send Query to any Postgres connection |
| get_conn_db | Get Connection Database |
| getConnDB | Get Connection Database |
| get_constraints | FUNCTION_TITLE |
| get_kcu | FUNCTION_TITLE |
| get_table | Get Full Table |
| getTable | Get Full Table |
| get_tc | FUNCTION_TITLE |
| grant_all_in_schema | Grant All Privileges on all Tables |
| grantSchema | Grant All Privileges to a Schema |
| is_closed | Is the Connection Closed? |
| isClosed | Is the Connection Closed? |
| is_conn_open | Is the Connection Open? |
| is_plr_installed | Is PLR Installed? |
| is_reserved | Is a string a reserve word? |
| isReserved | Is a string a reserve word? |
| join1 | 1st Degree Join |
| join2 | 2nd Degree Join |
| kill | Kill All Connections |
| link_query | Query using a link to SQL file |
| linkQuery | Query using a link to SQL file |
| link_send | Send a statument using a link to SQL file |
| linkSend | Send a statument using a link to SQL file |
| load_cache | Load a Cached Resultset from a SQL Query |
| loadCache | Load a Cached Resultset from a SQL Query |
| load_cached_join | Load a Cached Join Resultset |
| loadCachedJoin | Load a Cached Join Resultset |
| load_cached_query | Load a Cached Query Resultset |
| loadCachedQuery | Load a Cached Query Resultset |
| local | Local Postgres Database Function Family |
| local_connect | Connect to a Local Postgres Database |
| localConnect | Connect to a Local Postgres Database |
| local_file_query | Query local Postgess from a file |
| localFileQuery | Query local Postgess from a file |
| local_file_send | Send Statement to a local Postgess from a file |
| localFileSend | Send Statement to a local Postgess from a file |
| local_query | Query local Postgess |
| localQuery | Query local Postgess |
| local_send | Send a SQL Statement to a Local Postgres |
| localSend | Send a SQL Statement to a Local Postgres |
| log_error_ff | Log an Error Function Factory |
| log_start_ff | Log a Start Function Factory |
| log_stop_ff | Log a Stop Function Factory |
| lowLevel_typewrite_activity | Typewrite An Activity |
| lowLevel_typewrite_alert_danger | Typewrite Alert Danger |
| lowLevel_typewrite_alert_success | Typewrite Alert Success |
| lowLevel_typewrite_sql | Typewrite SQL |
| ls_db | List Databases |
| ls_extensions | List Extensions |
| ls_fields | List Fields |
| lsFields | List Fields |
| ls_schema | List Schemas |
| lsSchema | List Schemas |
| ls_tables | List Tables |
| lsTables | List Tables |
| ls_users | List Users |
| make_local_conn_details | Make a local Postgres Connection Details object |
| makeLocalConnDetails | Make a local Postgres Connection Details object |
| migrate | Migrate Tables |
| open_conn | Open a Connection in the 'pg13_connection_env' |
| parse_sql | Parse SQL into Single Statements |
| parseSQL | Parse SQL into Single Statements |
| paste_wheres | Paste All Drafted Where Statements |
| pasteWheres | Paste All Drafted Where Statements |
| peek | Peek |
| pg13 | pg13 Wrappers to DatabaseConnector and SqlRender Packages |
| pg13_env | PG13 Environment S4 Class |
| pg13_env_methods | Methods: PG13 environment |
| pipe | Pipe operator |
| pivot_table | Pivot a Table |
| q_creds_ff | Query Function Factory |
| q_fun_ff | Query Function Factory using Connection Expression |
| query | Query |
| query_field_type | Get Field Datatypes |
| quietly.conn_db | Connect without Console Messages |
| quietly.connDB | Connect without Console Messages |
| read_table | Read an Entire Table |
| readTable | Read an Entire Table |
| read_view | Read View |
| refresh_mview | Refresh a Materialized View |
| refresh_table | Refresh Table with New Data |
| refreshTable | Refresh Table with New Data |
| rename_db | Rename a Database |
| renameDB | Rename a table in a Postgres schema |
| rename_schema | Rename a Schema |
| rename_table | Rename a table in a Postgres schema |
| renameTable | Rename a table in a Postgres schema |
| render_copy | Render SQL to copy a file to a table |
| renderCopy | Render SQL to copy a file to a table |
| render_create_db | Render SQL to Create Database |
| renderCreateDB | Render SQL to Create Database |
| render_create_schema | Render SQL to Create a Schema |
| renderCreateSchema | Render SQL to Create a Schema |
| render_drop_schema | Render SQL to Drop a Schema |
| renderDropSchema | Render SQL to Drop a Schema |
| render_drop_table | Render SQL to Drop a Table |
| renderDropTable | Render SQL to Drop a Table |
| render_grant_schema | Render GRANT ALL PRIVILEGES |
| renderGrantSchema | Render GRANT ALL PRIVILEGES |
| render_info_schema_cols | Render SQL that returns Column Information |
| renderInfoSchemaCols | Render SQL that returns Column Information |
| render_ls_schema | Render SQL to List All Schema |
| renderLsSchema | Render SQL to List All Schema |
| render_rename_db | Render SQL to Rename a Table |
| renderRenameDB | Render SQL to Rename a Table |
| render_rename_table | Render SQL to Rename a Table |
| renderRenameTable | Render SQL to Rename a Table |
| render_row_count | Render SQL for a Table Row Count |
| renderRowCount | Render SQL for a Table Row Count |
| rm_if_closed | Remove a Closed Connection Object |
| rmIfClosed | Remove a Closed Connection Object |
| saveSQL | Export a sql statement to a file |
| schema_exists | Does a schema exist? |
| search_table | Search a Table for a Value |
| searchTable | Search a Table for a Value |
| see_conn | See the Connections in 'pg13_connection_env' |
| send | Send a SQL Statement to Postgres |
| send_ff | Send Function Factor |
| send_list | Send a List of SQL Statements |
| sendList | Send a List of SQL Statements |
| source_file_path | Get SourceFile Path |
| sourceFilePath | Get SourceFile Path |
| s_quo | Wrap with Single Quotes |
| sQuo | Wrap with Single Quotes |
| summarizeDB | FUNCTION_TITLE |
| summarize_field | Summarize the Counts and Values of a Field |
| summarize_fields | Summarize 1 or more Fields |
| summarize_schema | Summarize all Fields in a Schema |
| summarizeSchema | Summarize a Schema |
| summarize_table | Summarize all Fields in a Table |
| table_exists | Does a table exist? |
| table.path | Construct schemaTableName |
| terminate_build | Terminate a SQL Statement with a semicolon |
| terminateBuild | Terminate a SQL Statement with a semicolon |
| typewrite_activity | Typewrite Activity |
| typewrite_alert_danger | Typewrite Alert Danger |
| typewrite_alert_success | Typewrite Alert Success |
| typewrite_sql | Typewrite SQL |
| with_timeout | Wrap to include a timeout to evaluation. |
| write_sql_file | Export a sql statement to a file |
| write_staging_table | Write a Staging Table. |
| writeStagingTable | Write a Table that is Dropped On Exit |
| write_table | Write a Table |
| writeTable | Write a Table |
| write_table2 | Write a Table |
| writeTable2 | Write a Table |
