[postgis-users] osm2pgsql schema and table name

[Stephen Woodbridge]

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)