Re: Convert Arbitrary Table to Array?

Lee Hughes <lee(at)hughesys(dot)com> writes:
> Hi, I need a function that accepts a table name and returns a 2-dimensional
> array of the table data.

Well, in 8.3 and up there are arrays of composite types, so you can
do something like

select array(select mytable from mytable);

However you are not going to be able to encapsulate that as a function
real well, because of the question of what is the function's result
type.

You should also realize that this approach is not going to scale to
large tables. You don't want to get into pushing around arrays of more
than say a couple of megabytes.

Personally I'd be wondering exactly where this requirement comes from
and whether it doesn't betoken severe database-ignorance in the
application design.

regards, tom lane