Get remote table metadata

Get remote table metadata

get_metadata(x)

Arguments

x	An object of class tbl_lazy produced by get_table()

Value

A named list of remote table metadata

Author

Ernest Guevarra

Examples

x <- get_table(con = connect_oxcovid19(), tbl_name = "epidemiology")
get_metadata(x)
#> $Name
#> <IDENT> epidemiology
#> 
#> $Source
#> src:  postgres  [covid19@covid19db.org:5432/covid19]
#> tbls: administrative_division, baseline_mortality, diagnostics, epidemiology,
#>   epidemiology_england_msoa, geography_columns, geometry_columns,
#>   government_response, mobility, spatial_ref_sys, surveys, weather, world_bank,
#>   world_bank_time_series
#> 
#> $`DBI connection`
#> <PqConnection> covid19@covid19db.org:5432
#> 
#> $`Query text`
#> <SQL> SELECT *
#> FROM "epidemiology"
#> 
#> $`Query plan`
#> [1] "                                                              QUERY PLAN\n1 Seq Scan on epidemiology  (cost=0.00..56308.85 rows=1594885 width=120)"
#>