[postgis-users] "Field xx renamed to XX_01"

[Stefan Schwarzer]

>> But the problem remains: My dbf file shows, for example, the column
>> "id" and another "id_01". So all columns are doubled and an "_01"
>> added to the column name...
>>
>> Stef
>
>
> Hi Stefan,
>
> Unfortunately there is not enough information here for us to find out
> what is happening. For example, which version of PostGIS/PostgreSQL  
> are
> you using? (SELECT version() / SELECT postgis_full_version() ). Also
> you'd need to supply a .sql file containing the definitions for your
> table along with 3-4 sample geometries, plus with the resulting DBF  
> file
> that is produced.
>

Hi,

here is the command I use to export the table2shapefile:

	pgsql2shp -k -f glaciers my_database glaciers

________________________________________________________________________ 
_________________


Here are the dbf titels (with one exempl. entry):

	id   name   country_id   lat   long   id_01   name_01   country_01    
lat_01   long_01
	1037   Austre Broggerbreen   852   78.8830000000   11.8330000000     
1037    Austre Broggerbreen    852   78.8830000000   11.8330000000

________________________________________________________________________ 
_________________


PostGIS version:

	PostgreSQL 8.1.2 on powerpc-apple-darwin8.4.0, compiled by GCC  
powerpc-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc.  
build 5247)
	POSTGIS="1.1.1" GEOS="2.2.1-CAPI-1.0.1" PROJ="Rel. 4.4.9, 29 Oct  
2004" USE_STAT

________________________________________________________________________ 
_________________


And here is the SQL file for the table:

SET SESSION AUTHORIZATION 'ss_admin';

SET search_path = "public", pg_catalog;

-- Definition

-- DROP TABLE "public"."glaciers";
CREATE TABLE "glaciers" (
     "id" integer NOT NULL,
     "name" character varying(23),
     "country_id" integer,
     "lat" double precision,
     "long" double precision,
     "the_geom" geometry,
     CONSTRAINT "glaciers_pkey" PRIMARY KEY (id)
) WITH OIDS;

COPY "glaciers" FROM stdin;
1037	Austre Broggerbreen	852	78.882999999999996	11.833	 
00000000014027AA7EF9DB22D14053B883126E978D
1050	Cares\\303\\250r	444	46.5	10.667	 
0000000001402555810624DD2F4047400000000000
1055	Djankuat	748	43.200000000000003	42.767000000000003	 
00000000014045622D0E560419404599999999999A
1035	Enchaurren Norte	180	-33.582999999999998	-70.132999999999996	 
0000000001C0518883126E978DC040CA9FBE76C8B4
1039	Engabreen	672	66.650000000000006	13.85	 
0000000001402BB333333333334050A9999999999A
1049	Gries	864	46.5	8.3000000000000007	 
0000000001402099999999999A4047400000000000
1043	Gr\\303\\245subreen	672	61.649999999999999	8.5999999999999996	 
00000000014021333333333333404ED33333333333
1031	Gulkana	944	63.267000000000003	-145.417	 
0000000001C0622D5810624DD3404FA22D0E560419
1045	Hardangerjokulen	672	60.533000000000001	7.367	 
0000000001401D77CED916872B404E44395810624E
1041	Hellstugubreen	672	61.566000000000003	8.4329999999999998	 
00000000014020DDB22D0E5604404EC872B020C49C
1052	Hintereisferner	56	47.082999999999998	10.917	 
00000000014025D5810624DD2F40478A9FBE76C8B4
1053	Kesselwandferner	56	46.829999999999998	10.800000000000001	 
0000000001402599999999999A40476A3D70A3D70A
1060	Leviy Aktru	748	50.082999999999998	87.683000000000007	 
00000000014055EBB645A1CAC140490A9FBE76C8B4
1059	Maliy Aktru	748	50.082999999999998	87.75	 
00000000014055F0000000000040490A9FBE76C8B4
1036	Midre Lov\\303\\251nbreen	852	78.882999999999996	12.067	 
00000000014028224DD2F1A9FC4053B883126E978D
1044	Nigardsbreen	672	61.716999999999999	7.133	 
0000000001401C883126E978D5404EDBC6A7EF9DB2
1058	No. 125 (Vodopadniy)	748	50.100000000000001	87.700000000000003	 
00000000014055ECCCCCCCCCCD40490CCCCCCCCCCD
1033	Place	160	50.433	-122.59999999999999	 
0000000001C05EA666666666664049376C8B439581
1048	Sarennes	304	45.109999999999999	6.1660000000000004	 
00000000014018A9FBE76C8B4440468E147AE147AE
1046	Silvretta	864	46.832999999999998	10.08	 
0000000001402428F5C28F5C2940476A9FBE76C8B4
1051	Sonnblickkees	56	47.049999999999997	12.949999999999999	 
00000000014029E666666666664047866666666666
1034	South Cascade	944	48.350000000000001	-121.05	 
0000000001C05E43333333333340482CCCCCCCCCCD
1047	St. Sorlin	304	45.183	6.1660000000000004	 
00000000014018A9FBE76C8B444046976C8B439581
1040	Storbreen	672	61.566000000000003	8.1329999999999991	 
0000000001402044189374BC6A404EC872B020C49C
1038	Storglaci\\303\\244ren	860	67.900000000000006	18.567	 
000000000140329126E978D4FE4050F9999999999A
1056	Tsentralniy Tuyuksuyski	476	43.049999999999997	 
77.082999999999998	00000000014053454FDF3B645A4045866666666666
1057	Urumqihe S. No. 1	184	43.082999999999998	86.816999999999993	 
00000000014055B449BA5E353F40458A9FBE76C8B4
1054	Vernagtferner	56	46.883000000000003	10.817	 
00000000014025A24DD2F1A9FC4047710624DD2F1B
1032	Wolverine	944	60.399999999999999	-148.917	 
0000000001C0629D5810624DD3404E333333333333
1042	\\303\\205lfotbreen	672	61.75	5.6500000000000004	 
0000000001401699999999999A404EE00000000000
\.

-- Indexes

CREATE UNIQUE INDEX glaciers_pkey ON glaciers USING btree (id);
CREATE INDEX glaciers_the_geom_gist ON glaciers USING gist (the_geom);

________________________________________________________________________ 
_________________


Hope this helps to identify the problem.

Thanks for your precious help!

Stef