[postgis-users] osm2pgsql schema and table name

yvecai yvecai at gmail.com
Fri Mar 30 09:54:20 PDT 2012


The only option to use -c without data loss is to use -d 
'mynewandemptydatabase'.
Schema and tablenames are hard-coded in osm2pgsql: it is a highly 
specialized tool.
Yves

Le 30/03/2012 18:38, Stephen Woodbridge a écrit :
> On 3/30/2012 11:59 AM, Francois Hugues wrote:
>> Hello user list,
>>
>> A little question not directly related to postgis but i'm afraid 
>> about making a mistake which could results in data loss when i will 
>> use create option in osm2pgsql.
>>
>> I did not find the way to specify the schema and table name i would 
>> like to use to import data.
>>
>> Does something like osm2pgsql -c schema.tablename could work ?
>>
>> Else which are the default parameters of importation ? Public schema 
>> ? File name as table name ?
>>
>> I hope i'm not disturbing to much the mailing list,
>> Thanks in advance for your answers,
> $ man osm2pgsql
>
> OSM2PGSQL(1) OSM2PGSQL(1)
>
>
>
> NAME
>        osm2pgsql - Openstreetmap data to PostgreSQL converter.
>
> SYNOPSIS
>        osm2pgsql [options] planet.osm
>        osm2pgsql [options] planet.osm.{gz,bz2}
>        osm2pgsql [options] file1.osm file2.osm file3.osm
>
> DESCRIPTION
>        This manual page documents briefly the osm2pgsql command.
>
>        osm2pgsql  imports  data  from  OSM  file(s) into a PostgreSQL 
> database
>        suitable for use by the Mapnik renderer.
>        OSM  planet  snapshots  can  be  downloaded  from 
> http://planet.openâ
>        streetmap.org
>
>
> OPTIONS
>        These  programs  follow  the  usual  GNU command line syntax, 
> with long
>        options starting with two  dashes  (â-â).   A  summary  of 
> options  is
>        included below.
>
>        -a|--append
>               Add  the  OSM  file  into the database without removing 
> existing
>               data.
>
>        -b|--bbox
>               Apply a bounding box filter on the imported data Must be 
>  speciâ
>               fied     as:     minlon,minlat,maxlon,maxlat     e.g. 
>  --bbox
>               -0.5,51.25,0.5,51.75
>
>        -c|--create
>               Remove existing data from the database. This is the 
> default  if
>               --append is not specified.
>
>        -d|--database
>               The  name  of  the  PostgreSQL  database to connect to 
> (default:
>               gis).
>
>        -l|--latlong
>               Store data in degrees of latitude & longitude.
>
>        -m|--merc
>               Store data in proper spherical mercator, not OSM merc
>
>        -E|--proj num
>               Use projection EPSG:num
>
>        -u|--utf8-sanitize
>               Repair bad UTF8 input data (present in  planet  dumps 
> prior  to
>               August 2007). Adds about 10% overhead.
>
>        -p|--prefix
>               Prefix for table names (default planet_osm)
>
>        -U|--username
>               Postgresql user name.
>
>        -W|--password
>               Force password prompt.
>
>        -H|--host
>               Database server hostname or socket location.
>
>        -P|--port
>               Database server port.
>
>        -h|--help
>               Help information.
>               Add -v to display supported projections.
>               Use   -E   to   access   any   espg   projections 
> (usually  in
>               /usr/share/proj/epsg)
>
>        -v|--verbose
>               Verbose output.
>
>
> SUPPORTED PROJECTIONS
>        Latlong             (-l) SRS:  4326 (none)
>        WGS84 Mercator      (  ) SRS:   3395  +proj=merc  +datum=WGS84 
>  +k=1.0
>        +units=m +over +no_defs
>        Spherical  Mercator   (-m)  SRS:900913 +proj=merc +a=6378137 
> +b=6378137
>        +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m 
> +nadgrids=@null
>        +no_defs +over
>
>
> SEE ALSO
>        proj(1), postgres(1).
>
> AUTHOR
>        osm2pgsql was written by Jon Burgess and Artem Pavlenko.
>
>        This  manual page was written by Andreas Putzo 
> <andreas at putzo.net>, for
>        the Debian project (but may be used by others).
>
>
>
>                                 April 12, 2008 OSM2PGSQL(1)
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>




More information about the postgis-users mailing list