Re: User-defined print format for extension-defined types in psql output

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Peter Devoy <peter(at)3xe(dot)co(dot)uk>, "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: User-defined print format for extension-defined types in psql output
Date: 2017-12-15 09:59:20
Message-ID: 1513331960.2504.22.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Devoy wrote:
> To make inspecting PostGIS tables in psql easier I have written a
> function which outputs PostGIS Geometry objects as a string of ASCII
> art.
>
> Please does anyone know if there is there some way I can have my
> function called automatically by psql instead of me writing it into
> the query each time? E.g. a user defined \pset option or some sort of
> extension API which gives me access to the print logic or
> 'presentation layer' of psql.
>
> By 'automatically' I mean through association with the PostGIS geometry types.

All I can think of is changing the output function of the PostGIS data types,
but that would require a C function.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Finzel 2017-12-15 14:44:38 Re: Dependency tree to tie type/function deps to a table
Previous Message Laurenz Albe 2017-12-15 07:21:06 Re: Can postgresql ignore DST ?