[GENERAL] can i use an array as a table (in the from clause)

[Coarr, Matt]

Is there some way that I can treat a two dimensional array as a table
that can be referenced in the from clause?
 
Thanks,
Matt

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[GENERAL] any way to query for current connections to db?

[Coarr, Matt]

Hi,
 
Is there any way to query the database to identify what the current
connections are (connections, sessions, or whatever you want to call
them)?
 
This would be something similar to oracle's v$session view.
 
Thanks,
Matt