Man pages for patelm9/seagull
What the Package Does (One Line, Title Case)

connect_to_local_postgresConnect to Local PostGres Server
connect_to_mysql5.5Connect to MySQL v5.5 via Unix Sock using credentials stored...
create_schemaCreate schema for a database
create_tableCreate table in the given database
create_table_via_temp_fileWrites a dataframe to a new table via a temp file
dc_local_connDisconnect a connection to a local database
disconnect_local_postgresDisconnect from Postgres
drop_schemaDrop schema for a database
drop_tableDrop table in the given database
export_statement_to_fileExport a sql statement within a R object to a sql file
get_pg_queryQuery local Postgess
load_package_sqlsLoad all packaged SQLs
local_connCreate a conn object on a local database
pgQuerySend Query a Postgres connection
pgSendSend a SQL Statement to Postgres
prepare_vectorConvert vector to arguments
query_pg_from_fileQuery a local postgres database from a file
query_raw_githubQuery raw github sql
read_tableRead table in the given database
renameTableRename a table in a Postgres schema
renderRenameTableRender SQL to Rename a Table
write_query_where_inWrites a SQL query that includes a WHERE IN clause based on a...
write_sql_for_distinct_countsWrite sql that gets distinct counts
write_sql_for_random_recordsWrites SQL to get random records of a certain limit
write_sql_query_string_as_vectorWrite a SQL statement that loops over a word in a string
write_sql_statement_to_load_rrfReturn SQL statements into the console that loads RRF in raw...
write_sql_to_copy_from_csvWrites a dataframe as a table to the given database
write_sql_to_copy_from_delimWrites a dataframe as a table to the given database
write_sql_to_create_schemaWrite SQL to create a schema
write_sql_to_drop_create_table_from_dfWrites a DROP TABLE and CREATE TABLE sql statement for a...
write_sql_to_drop_schemaWrite SQL to drop a schema
write_where_in_stringTake a vector and create a string for WHERE IN SQL
patelm9/seagull documentation built on July 19, 2020, 5:52 a.m.