How to assemble all fields of (any) view into a string?

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: How to assemble all fields of (any) view into a string?
Date: 2016-09-07 20:15:57
Message-ID: CAD3a31UcP5Fz=LNox32DHH9EeGHng2Lmp0OOSVF1QZqEcQsCkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. Using version 9.2. I'm trying to create a function that will take a
record from any view and assemble it into a string, for export to another
system. For example, this view:

> \d ebh_gain
View "public.ebh_gain"
Column | Type | Modifiers
-------------------+---------------+-----------
reporting_unit_id | character(3) |
case_id | character(10) |
event_date | character(8) |
ids_score | character(1) |
eds_score | character(1) |
sds_score | character(1) |
kc_auth_number | integer |
king_county_id | integer |

would get converted into a string with all the fields concatenated
together, and space-padded to their full lengths.

My original idea was to do this in TCL by passing a record and a view
name. The function would then look up the columns in the
information_schema, and use that info to assemble and return the string.
But it looks like TCL functions won't accept a record as an argument.

Any suggestions or advice most welcome. Thanks!

Ken
--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://agency-software.org/demo/client
<https://agency-software.org/demo/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-09-07 20:22:34 Re: How to assemble all fields of (any) view into a string?
Previous Message Adrian Klaver 2016-09-07 20:13:53 Re: joined tables with USING and GROUPBY on the USING() column