>From a user's standpoint, PostgreSQL (and PostGIS) does not write files. In
order to read/write files, you need tools (psql, pgAdminIII, pgsql2shp,
etc.). You need to write a custom tool for your situation in PHP.
Ignoring details, you will need a database connection from PHP to
PostgreSQL, run y
-users-boun...@postgis.refractions.net] On Behalf Of
zhang zhe
Sent: Tuesday, 19 October 2010 11:06 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] create xml file from sql table
hello,
I tried your code
psql -At -U postgres -c "select table_to_xml('build
have any idea?
Thanks
Date: Tue, 19 Oct 2010 21:54:11 +1000
From: josh.pres...@rpdata.com
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] create xml file from sql table
Hi,
You can use psql to run your query from the command line.
psql -At -U {username} -c “select
users@postgis.refractions.net
Subject: Re: [postgis-users] create xml file from sql table
Hello,
Thanks. Do you know how to run this in php. I am writting php file
which query from postgres and produce xml file. Do you know how to do it
with php?
Thanks
Date: Tue, 19 Oct
: [postgis-users] create xml file from sql table
Hi,
You can use psql to run your query from the command line.
psql -At -U {username} -c “select table_to_xml(‘building3’,true,true,’’);”
{database} > query.xml
-A unaligned output (no formatting of results for display purposes)
-t Rows o
On Behalf Of
zhang zhe
Sent: Tuesday, 19 October 2010 9:37 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] create xml file from sql table
Hello,
Does anyone knows how to generate xml file from postgres table.
select table_to_xml('building3',true,true,'
Hello,
Does anyone knows how to generate xml file from postgres table.
select table_to_xml(‘building3’,true,true,’’);
will print xml file in data output . How can I generate a file, and save it to
directory automatically. I want to write this function in php code.
Thank you very much.
