Home > mailing lists

Convert Arbitrary Table to Array? - Mailing list pgsql-general

From	Lee Hughes
Subject	Convert Arbitrary Table to Array?
Date	February 9, 2009 15:52:20
Msg-id	2d739b560902090852h71e293a9qa9aff6e84e1448d9@mail.gmail.com Whole thread Raw
Responses	Re: Convert Arbitrary Table to Array? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

Hi, I need a function that accepts a table name and returns a 2-dimensional array of the table data.

I found some related posts on this and other forums and tried several approaches with plpgsql but have had no success.

I know I can pull the table data out to the application tier and transform it from there but I would really prefer to keep it in the database.

Any help is greatly appreciated.

Thanks-

Lee

pgsql-general by date:

From: Stephen Frost
Date: 09 February 2009, 15:25:56
Subject: Re: Out of memory on SELECT in 8.3.5

From: Alvaro Herrera
Date: 09 February 2009, 15:59:17
Subject: Re: Pet Peeves?

Convert Arbitrary Table to Array? - Mailing list pgsql-general

Previous

Next