Thanks Paul. I am looking for utility that help us to export table definitions and data from an Oracle spatial schema and import them into Postgres (Postgis) database. Thanks, Majid
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Ramsey Sent: March 10, 2010 1:15 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] FW: Inserting value into geometry column error:Array value must start with "{" or dimension. ogr2ogr http://www.gdal.org/ogr2ogr.html On Wed, Mar 10, 2010 at 10:07 AM, Majid Kazemi <[email protected]> wrote: > Thanks kevin; > It is working now. > I have to add "{" > INSERT INTO guest(ID, NAME, GEOM) > VALUES (1,'{First Geometry}',ST_GeomFromText('LINESTRING(2 3,4 5,6 5,7 > 8)', -1)); > > I have another question: > Any ideas how can I export Oracle spatial to Postgres (postgis)? > I saw there is a perl script called ora2pg.pl. Is there any other > tools available to perform this migration? > Thanks, Majid > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > Kevin Neufeld > Sent: March 10, 2010 12:33 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] FW: Inserting value into geometry column > error: Array value must start with "{" or dimension. > > This is DDL for a table named "gtest", but you're inserting into a > table named "guest". I suspect you're accidentally inserting into a > different table, one where the "GEOM" column is not of type "geometry". > > In any case, your posted DDL is correct - so is this: > CREATE TABLE gtest (ID int4, NAME varchar(20), GEOM geometry); > > Your insert statement then should work correctly: > INSERT INTO gtest(ID, NAME, GEOM) > VALUES (1,'First Geometry',ST_GeomFromText('LINESTRING(2 3,4 5,6 5,7 > 8)', -1)); > > Cheers, > Kevin > > > On 3/10/2010 9:18 AM, Majid Kazemi wrote: >> Here is the DDL for Table creation: >> CREATE TABLE gtest ( ID int4, NAME varchar(20) ); SELECT >> AddGeometryColumn('', 'gtest','geom',-1,'LINESTRING',2); >> Thanks, Majid >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of >> Kevin Neufeld >> Sent: March 10, 2010 11:48 AM >> To: PostGIS Users Discussion >> Subject: Re: [postgis-users] FW: Inserting value into geometry column >> error: Array value must start with "{" or dimension. >> >> What's the DDL for your guest table? >> >> On 3/10/2010 8:29 AM, Majid Kazemi wrote: >>> *From:* Majid Kazemi >>> *Sent:* March 10, 2010 11:02 AM >>> *To:* '[email protected]' >>> *Subject:* Inserting value into geometry column error: Array value >>> must start with "{" or dimension. >>> >>> Hello all; >>> Thanks for everyone help. I finally managed to install and configure >>> Postgis. >>> Now, I am trying to insert the following into a table with Geom >> column. >>> >>> INSERT INTO guest(ID, NAME, GEOM) >>> >>> VALUES (1,'First Geometry',ST_GeomFromText('LINESTRING(2 3,4 5,6 5,7 >>> 8)', -1)); >>> >>> I am receiving the following error: >>> >>> Array value must start with "{" or dimension. >>> >>> your help will highly be appreciated. >>> >>> Thanks, Majid >>> >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
