From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to assemble all fields of (any) view into a string? |
Date: | 2016-09-07 20:22:34 |
Message-ID: | f3e9a81c-f194-35a2-ea05-fd471b13faf3@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)tanzer(at)agency-software(dot)org <mailto:ken(dot)tanzer(at)agency-software(dot)org>
> (253) 245-3801
>
> Subscribe to the mailing list
> <mailto:agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
> learn more about AGENCY or
> follow the discussion.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Tanzer | 2016-09-07 20:36:55 | Re: How to assemble all fields of (any) view into a string? |
Previous Message | Ken Tanzer | 2016-09-07 20:15:57 | How to assemble all fields of (any) view into a string? |