From 2aa734127c41827423c72ef9e0f4ac352c3a00b2 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Wed, 4 Jul 2012 13:12:58 +0000 Subject: [PATCH] Fix pgsql2shp for big-endian systems (#1900) Submitted By: Ryan Oliver git-svn-id: http://svn.osgeo.org/postgis/trunk@10034 b70326c6-7e19-0410-871a-916f4a2858ee --- loader/pgsql2shp-core.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/loader/pgsql2shp-core.c b/loader/pgsql2shp-core.c index 2a903f004..382c759d3 100644 --- a/loader/pgsql2shp-core.c +++ b/loader/pgsql2shp-core.c @@ -1928,11 +1928,11 @@ ShpDumperOpenTable(SHPDUMPERSTATE *state) { if (state->pgis_major_version > 0) { - sprintf(buf, "ST_asEWKB(ST_SetSRID(\"%s\"::geometry, 0), 'XDR')", state->geo_col_name); + sprintf(buf, "ST_asEWKB(ST_SetSRID(\"%s\"::geometry, 0), 'XDR') AS _geoX", state->geo_col_name); } else { - sprintf(buf, "asbinary(\"%s\"::geometry, 'XDR')", + sprintf(buf, "asbinary(\"%s\"::geometry, 'XDR') AS _geoX", state->geo_col_name); } } -- 2.40.0