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

[Marvin]

Hi, Dean,

Thanks for the info. I tried your command but got the following error message:

ogr2ogr -f "PostgreSQL" PG:"dbname=test user=someuser mySchema host=localhost password=somepass" .
ERROR 1: PQconnectdb failed.
missing "=" after "mySchema" in connection info string

ERROR 1: PostgreSQL driver doesn't currently support database creation.
Please create database with the `createdb' command.
PostgreSQL driver failed to create PG:dbname=test user=someuser mySchema host=localhost password=somepass

Do I need to insert anything between "mySchema" and the user name? BTW, I use TWTools 1.3.3. Is it the version you use?




 --- On Tue 07/31, Dean C. Mikkelsen < dcmikkelsen at shaw.ca > wrote:
From: Dean C. Mikkelsen [mailto: dcmikkelsen at shaw.ca]
To: gdal-dev at lists.maptools.org
Date: Tue, 31 Jul 2007 19:18:54 -0700
Subject: RE: [Gdal-dev] Re: [FWTools] org2org: import TIGER data into a	specificschema in PostgreSQL

Hi there.Have you tried:ogr2ogr -f "PostgreSQL" PG:"dbname=test user=someuser myschemahost=localhost password=somepass"I've added the "myschema".When I first started working with PostGIS last week, I found I had to do theusername and schema one after the other in order place the data in thecorrect 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 MarvinSent: Tuesday, July 31, 2007 1:11 PMTo: gdal-dev at lists.maptools.orgSubject: [Gdal-dev] Re: [FWTools] org2org: import TIGER data into aspecificschema in PostgreSQLHi, All,I'm trying to import TIGER data into a PostgreSQL database. The command Iuse is:ogr2ogr -f "PostgreSQL" PG:"dbname=test user=someuser host=localhostpassword=somepass" .This command put the data into the "public" schema. I'm wondering if thereis a way to import the data into a specific schema such as "mySchema". Itried to use the option "-dsco" 
as:ogr2ogr -f "PostgreSQL" PG:"dbname=test user=someuser host=localhostpassword=somepass" -dsco schema=mySchema .But it still put the data into the "public" schema. Could anyone please giveany suggestion? Thanks._______________________________________________Join Excite! - http://www.excite.comThe most personalized portal on the Web!_______________________________________________Gdal-dev mailing listGdal-dev at lists.maptools.orghttp://lists.maptools.org/mailman/listinfo/gdal-dev_______________________________________________Gdal-dev mailing listGdal-dev at lists.maptools.orghttp://lists.maptools.org/mailman/listinfo/gdal-dev

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