[Gdal-dev] Re: [FWTools] org2org: import TIGER data into a specificschema in PostgreSQL

[Dean C. Mikkelsen]

Hi there.

Have you tried:

ogr2ogr -f "PostgreSQL" PG:"dbname=test user=someuser myschema
host=localhost password=somepass"

I've added the "myschema".

When I first started working with PostGIS last week, I found I had to do the
username and schema one after the other in order place the data in the
correct schema.

Let me know if this works.

Cheers,
Dean


-----Original Message-----
From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Marvin
Sent: Tuesday, July 31, 2007 1:11 PM
To: gdal-dev at lists.maptools.org
Subject: [Gdal-dev] Re: [FWTools] org2org: import TIGER data into a
specificschema in PostgreSQL



Hi, All,

I'm trying to import TIGER data into a PostgreSQL database. The command I
use is:

ogr2ogr -f "PostgreSQL" PG:"dbname=test user=someuser host=localhost
password=somepass" .

This command put the data into the "public" schema. I'm wondering if there
is a way to import the data into a specific schema such as "mySchema". I
tried to use the option "-dsco" as:

ogr2ogr -f "PostgreSQL" PG:"dbname=test user=someuser host=localhost
password=somepass" -dsco schema=mySchema .

But it still put the data into the "public" schema. Could anyone please give
any suggestion? Thanks.




_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!


_______________________________________________
Gdal-dev mailing list
Gdal-dev at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/gdal-dev