obm_sql_query: SQL Interface
In OpenBioMaps/obm.r: OpenBioMaps API interface for R

obm_sql_query

R Documentation

SQL Interface

Description

It is a simple SQL Query interface function

Usage

obm_sql_query(
  sqlcmd,
  username = "",
  password = "",
  paranoid = T,
  port = 5432,
  database = "gisdata"
)

Arguments

sqlcmd

username most probably automatically set by create_pg_user module password most probably automatically set by create_pg_user module paranoid password promt type postgres server port, default is 5432 database remote database, default is gisdata

Examples

obm_sql_query("SELECT DATE_PART('day', enddate::timestamp - startdate::timestamp) AS days FROM nestboxes WHERE enddate IS NOT NULL AND startdate IS NOT NULL ORDER BY days")

OpenBioMaps/obm.r documentation built on Feb. 22, 2023, 5:47 p.m.