[FWTools] Export out to SQL file.

[Bryan Keith]

Frank Warmerdam wrote:
> On 4/16/07, Murali Maddali <murali.maddali at uai.com> wrote:
>>
>> Hello All,
>>
>> I was wondering if it is possible to export data out to an SQL file (like
>> pg_dump with bunch of insert statements.) using ogr2ogr utility. I tried to
>> look up on the web but couldn't find any.
>>
>> Appreciate all your help or else you can point me to the right direction.
> 
> Murali,
> 
> I can't think of any of the existing drivers that will support
> doing something like this.  Sorry.
> 
> Best regards,
> 

Murali,

I don't know if this will help, but you can use ogr2ogr to create a 
shapefile and then use shp2pgsql (included with postgis) to create 
postgres/postgis sql from the shapefile.

Bryan