Moving Data In and Out of PostGIS - PostGIS - page 37

13. ChecksomeoftherecordsthathavebeenuploadedtothePostGIStableby
using SQL:
postgis_cookbook=# SELECT
upload_datetime, shapefile,
ST_AsText(the_geom) FROM
chp01.hs_uploaded WHERE ISO2='AT';
upload_datetime |
shapefile |
st_astext-------------------------------+-----------------------+----------------------Sun
Aug 26 01:58:44 CEST 2012 |
out_shapefiles/AT.shp | POINT(14.333
48.279)Sun Aug 26 01:58:44 CEST 2012 |
out_shapefiles/AT.shp | POINT(14.347
48.277)Sun Aug 26 01:58:44 CEST 2012 |
out_shapefiles/AT.shp | POINT(14.327
48.277)...
(8 rows)
14. Check the same query with ogrinfo as well:
$ ogrinfo PG:"dbname='postgis_cookbook'
user='me' password='mypassword'"
chp01.hs_uploaded -where "iso2='AT'"
INFO: Open of
`PG:dbname='postgis_cookbook' user='me'
password='mypassword''using driver
`PostgreSQL' successful.Layer name:
chp01.hs_uploaded
Geometry: Point
Feature Count: 8
Extent: (-155.284000, -40.751000) -
(177.457000, 70.404000)
Layer SRS WKT:
GEOGCS["WGS 84",
...
FID Column = ogc_fid
Geometry Column = the_geom