Learn R Programming

db.r (version 0.1.3)

queries.pg: Queries for Postgres

Description

Queries for Postgres

Usage

queries.pg

Arguments

Format

List of 3
 $ column:List of 4
  ..$ head  : chr "select %s from %s limit %d;"
  ..$ all   : chr "select %s from %s;"
  ..$ unique: chr "select distinct %s from %s;"
  ..$ sample: chr "select %s from %s order by random() limit %d;"
 $ table :List of 5
  ..$ select: chr "select %s from %s;"
  ..$ head  : chr "select * from %s limit %d;"
  ..$ all   : chr "select * from %s;"
  ..$ unique: chr "select distinct %s from %s;"
  ..$ sample: chr "select * from %s order by random() limit %d;"
 $ system:List of 6
  ..$ schema_no_system       : chr "                select                    table_name                    , column_name                    , udt_name            "| __truncated__
  ..$ schema_with_system     : chr "                select                    table_name                    , column_name                    , udt_name            "| __truncated__
  ..$ schema_specified       : chr "                select                    table_name                    , column_name                    , udt_name            "| __truncated__
  ..$ foreign_keys_for_table : chr "            SELECT                kcu.column_name                , ccu.table_name AS foreign_table_name                , ccu.co"| __truncated__
  ..$ foreign_keys_for_column: chr "            SELECT                kcu.column_name                , ccu.table_name AS foreign_table_name                , ccu.co"| __truncated__
  ..$ ref_keys_for_table     : chr "            SELECT                ccu.column_name                , kcu.table_name AS foreign_table_name                , kcu.co"| __truncated__