<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ES link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>I’m trying to export a series of tables using
the pgsql2shp command. The ‘problem’ I have is that tables that are
empty do not export how I want them to- an empty dbf without column names is
exported. What I’m looking for is to be able to be able to export the
tables as shapefiles even if they have no records (in some case they’ll
have records, in others no), which would effectively give me three ‘empty’
files (shp, shx and dbf), the dbf however would have the column names.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>An ideas to get around this problem?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Cheers,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Matt<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellpadding=0 align=left width="100%"
bgcolor=white style='width:100.0%;background:white'>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Matt
Doughty</span></font><o:p></o:p></p>
</td>
<td rowspan=5 valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><img width=90
height=100 id="_x0000_i1025" src="cid:image001.jpg@01C83B18.715021F0"><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>GEOGRAMA
S.L.</span></font><font face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Tel.:
+34 945 13 13 72 652 77 14 15</span></font><font
face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Fax:
+34 945 23 03 40 </span></font><font face=Arial><span style='font-family:
Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>www.geograma.com</span></font><font
face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>