Postgres Pro
Downloads
Home   >   mailing lists

Name/Value array to table row - Mailing list pgsql-sql

From Michael Moore
Subject Name/Value array to table row
Date
Msg-id CACpWLjPr70JnLO76v66oMyo=-Cdk7SxkDGwO5fh4w1uRKPmp4A@mail.gmail.com
Whole thread Raw
Responses Re: Name/Value array to table row  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
I have an array that is a name value pair where the name is the name of a column in a table. There are about 300 columns. I want to use all of the name value pairs to construct the table row. I've thought about using jsonb or hstore. I'm sure I could write some ugly code to do this, but what is the BEST way to go about this?
I.E 
ARRAY
name |value
-----------
animal | 'cat'
lbs      | 20

create table animals (animal text, lbs number);
thanks,
Mike

pgsql-sql by date:

Previous
From: Hector Vass
Date:
Subject: Re: regexp_replace question/suggestions needed
Next
From: "David G. Johnston"
Date:
Subject: Re: Name/Value array to table row