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

[Obe, Regina]

 Sligh correction , I meant field name. Dbf field names have to be under
10 characters long.

-----Original Message-----
From: Obe, Regina 
Sent: Thursday, January 18, 2007 8:08 AM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] "Field xx renamed to XX_01"

Some other things to look for

1) Are the fields repeating under 10 characters or over 10 characters.
The pgsql2shp commandline will truncate them and put in _01 etc. if they
are greater than 10 characters because that is invalid length for a dbf
file name.  

2)This is just perhaps a silly thought.  Are you using the sql feature
and doing something like

"select *, id, field2, field3 from ..."

The * already includes all the fields and I'm not sure what happens if
you reinclude them.

Anyrate send us the full command you are passing to the pgsql2shp
command line too just so we rule out any obvious misuses. 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
Cave-Ayland
Sent: Thursday, January 18, 2007 2:40 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] "Field xx renamed to XX_01"

On Thu, 2007-01-18 at 08:11 +0100, Stefan Schwarzer wrote:

> Thanks. Indeed, with -k the column-titles are being kept in small 
> letters.
> 
> 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.


Kind regards,

Mark.


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.