From fay.du@versaterm.com Mon Mar 20 15:23:48 2006 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E42B69DCB9C for ; Mon, 20 Mar 2006 11:23:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01313-02 for ; Mon, 20 Mar 2006 11:23:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.versaterm.com (smtp.versaterm.biz [216.208.41.121]) by postgresql.org (Postfix) with ESMTP id CE0AF9DCAE3 for ; Mon, 20 Mar 2006 11:23:44 -0400 (AST) Received: from fay (unknown [198.73.216.184]) by smtp.versaterm.com (Postfix) with ESMTP id ACAB770002 for ; Mon, 20 Mar 2006 10:23:33 -0500 (EST) From: "Fay Du" To: Subject: pgsql2shp - Could not create dbf file Date: Mon, 20 Mar 2006 10:23:27 -0500 Message-ID: <004201c64c32$3c89afd0$b8d849c6@versaterm.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0043_01C64C08.53B3A7D0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.06 required=5 tests=[AWL=0.059, HTML_MESSAGE=0.001] X-Spam-Score: 0.06 X-Spam-Level: X-Archive-Number: 200603/308 X-Sequence-Number: 24654 This is a multi-part message in MIME format. ------=_NextPart_000_0043_01C64C08.53B3A7D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi everyone: I got an error when I use pgsal2shp. My server is Linux The command I used is: pgsql2shp -f newroads gisdb testarea Where, newroads is my out put file name, gisdb is database name, and testarea is table name. After hit enter button, I got the message: Initializing... Could not create dbf file What was wrong? Any help will be appreciated. Fay ------=_NextPart_000_0043_01C64C08.53B3A7D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi everyone:

I got an = error when I use pgsal2shp.

My server is Linux

The command I used is: pgsql2shp -f newroads gisdb testarea

Where, newroads is my out put file name, gisdb is database name, and testarea is table = name.

After hit = enter button, I got the message: = Initializing... Could not create dbf file

What was = wrong? Any help will be appreciated.

Fay

------=_NextPart_000_0043_01C64C08.53B3A7D0-- From schabi@logix-tt.com Mon Mar 27 14:51:39 2006 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3417A9DCCE2 for ; Mon, 27 Mar 2006 10:51:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80429-04 for ; Mon, 27 Mar 2006 10:51:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.logix-tt.com (unknown [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id EA3089DCBC8 for ; Mon, 27 Mar 2006 10:51:36 -0400 (AST) Received: from kingfisher.intern.logix-tt.com (T938b.t.pppool.de [89.55.147.139]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id E1ADC656CD; Mon, 27 Mar 2006 16:52:19 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 3850818148C82; Mon, 27 Mar 2006 16:51:51 +0200 (CEST) Message-ID: <4427FC07.5030302@logix-tt.com> Date: Mon, 27 Mar 2006 16:51:51 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Debian Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Fay Du Cc: pgsql-sql@postgresql.org Subject: Re: pgsql2shp - Could not create dbf file References: <004201c64c32$3c89afd0$b8d849c6@versaterm.com> In-Reply-To: <004201c64c32$3c89afd0$b8d849c6@versaterm.com> X-Enigmail-Version: 0.93.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.109 required=5 tests=[AWL=0.109] X-Spam-Score: 0.109 X-Spam-Level: X-Archive-Number: 200603/426 X-Sequence-Number: 24772 Hi, Fay, First, this would be better posted to the PostGIS lists, as pgsql2shp is a PostGIS utility, and not a PostgreSQL SQL query. Fay Du wrote: > The command I used is: pgsql2shp -f newroads gisdb testarea > > Where, newroads is my out put file name, gisdb is database name, > and testarea is table name. > > After hit enter button, I got the message: Initializing... Could > not create dbf file It seems that there was an error creating the newroads.dbf file - each shapefile consists of corresponding .shp, .dbf and .shx files. Do you have permissions on the directory to create those three files? Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org