#Postgresql cheat sheet pdf

Remap identifiers to ten character names. Specify the tablespace for the new index. Indexes will still use the default tablespace unless the -X parameter is also used. Specify the tablespace for the new table. Use geography type instead of geometry (requires lon/lat data) in WGS84 long lat (-s SRID=4326) Policy Specify NULL geometries handling policy (insert,skip,abort) Use wkt format (for postgis-0.x support - drops M - drifts coordinates).Д®ncoding The character encoding of Shape's attribute column. Generate simple geometries instead of MULTI geometries.Д¬onnect to the database as the specified user. Do not unescape attribute names and not skip the 'gid' attribute. Defaults to 5432.Д¬onnect to the database with the specified password. Use int4 type for all integer dbf fields.Д¬reate a GiST index on the geometry column.ДЄllows you to specify a database port other than the default. Use postgresql dump format (defaults to sql insert statments).Д®xecute each statement individually, do not use a transaction. Specify db server host name defaults to localhost. Specify the name of the geometry column to be (S) created (P) exported. Use this option to specify the name of the file to create

If -s :to_srid 1 is not specified then from_srid is assumed and no transformation happens.Дrops the table, then recreates it and populates it with current shape file data.ДЄppends shape file into current table, must be exactly the same table schema.Д¬reates a new table and populates it, default if you do not specify any options. New in 2.0.0 1, New in 1.5 2 General options: (P - pgsql2shp, S - shp2pgsql) Shp2pgsql generates an SQL script from ESRI shape and DBF files suitable for loading into a PostGIS enabled database. Pgsql2shp dumps a postgis database table, view or sql query to ESRI shape file format. Shp2pgsql and pgsql2shp are all located in the bin folder of the PostgreSQL install. PostGIS 2.0.0 pgsql2shp shp2pgsql Cheat Sheet

#Postgresql cheat sheet pdf

PostGIS 2.0 pgsql2shp shp2pgsql Command Line Cheatsheet PDF Version PostGIS 2.0 pgsql2shp shp2pgsql Command Line Cheatsheet