obm_sql_query: SQL Interface

Description Usage Arguments Examples

View source: R/openbiomaps.R

Description

It is a simple SQL Query interface function

Usage

1
2
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

1
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 Dec. 21, 2020, 1:09 a.m.