ecto_query: Querying the Database

In blex-max/ectosearchR: Simple Wrapper Package around DBI for SQL Querying Van Der Linde 2018 Ectomycorrhizal Dataset

Description

Query the Van Der Linde 2018 database and return results. Uses Postgres SQL.

Usage

ecto_query(sql)

Arguments

sql	A string corresponding to a postgres SQL query statement, which will be executed on the database.

Value

A dataframe containing the results of the executed SQL query

Examples

french_seqs <- ecto_query('SELECT sample_ID, sample_seq FROM seq_data  WHERE ICP_country_code = 1;');
all_country_codes <- ecto_query('SELECT DISTINCT Country, code_country FROM plot_metadata;');

blex-max/ectosearchR documentation built on Dec. 19, 2021, 10:41 a.m.