hello, I tried your code psql -At -U postgres -c “select table_to_xml(‘building3’,true,true,’’);” postgres > query.xml but it gives erro ident authentication failed for user "postgres" what should be the user name. I tried with localhost, it gives the same error. Do you have any idea? Thanks
Date: Tue, 19 Oct 2010 21:54:11 +1000 From: [email protected] To: [email protected] 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 table_to_xml(‘building3’,true,true,’’);” {database} > query.xml -A unaligned output (no formatting of results for display purposes) -t Rows only (ie no header, so your xml file to only has xml in it) If you don’t really need an automated way you can use the “Execute query to file” option in pgAdmin. Regards, Josh From: [email protected] [mailto:[email protected]] On Behalf Of zhang zhe Sent: Tuesday, 19 October 2010 9:37 PM To: [email protected] 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,’’); 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. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
