[postgis-devel] geographystyle feature request (external textual representation)

[Malek,Christophe [CMC]]

Hi strk,

I'm not sure how pg_dump decides which representation to use in its
dumps. I would assume it uses the "external textual representation" when
dumping to text (pg_dump -Fp) and uses the "external binary
representation" when dumping to binary (pg_dump -Fc) but it isn't
entirely clear from the documentation if this is true. The binary option
may just dump the actual "internal data type representation". I'm a
little surprised not to see all three options explicitly for dumping
unless the last two (external and internal binary) are always supposed
to be the same thing? HEXWKB (hexadecimal well known binary) sounds like
an appropriate format mainly for binary dumps.

I don't think I understand how GUC lifetime relates to what should be
output in a dump. Perhaps you could elaborate on the use case?

You can wait for a patch from me but you may be waiting a very very long
time ;)

- Chris

-----Original Message-----
From: postgis-devel-bounces at lists.osgeo.org
[mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Sandro
Santilli
Sent: 09 September, 2015 14:18
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] geographystyle feature request (external
textual representation)

On Wed, Sep 09, 2015 at 01:39:59PM -0400, Malek,Christophe [CMC] wrote:

> It is my understanding that this has been done in Postgres for the 
> date and interval data types using the commands:
> "SET DATESTYLE TO ISO" etc. or
> "SET INTERVALSTYLE TO POSTGRES" etc.
> 
> Postgis could perhaps include something similar:
> "SET GEORAPHYSTYLE TO WKT", "SET GEOGRAPHYSTYLE TO POSTGIS", etc. or 
> something along those lines to give users some more options.

I second the idea, as long as the GUC lifetime is that of a single
session, the dump should always be in proper HEXWKB.

As for time, I don't have it either. Can we wait for your patch ?

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel