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

On 09/07/2016 01:15 PM, Ken Tanzer wrote:

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.

I think an example is needed. I was thinking you wanted the field values transformed, but the below seems to indicate something different.

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//
/https://agency-software.org/demo/client/
ken.tanzer@agency-software.org <mailto:ken.tanzer@agency-software.org>
(253) 245-3801

Subscribe to the mailing list
<mailto:agency-general-request@lists.sourceforge.net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

--
Adrian Klaver
adrian.klaver@aklaver.com