So I'm using dblink to run a query on another db, which works fine.

I'm wondering if there is some shortcut I can use since I have the type the remote function is returning defined on my side so I don't need to list all the columns - so instead of select * from dblink('select * from someFooTypeReturningFunc()') as t1(col text, ....)
I could write select * from dblink('select ... ') as t1(footype)

I've poked over the docs and googled around, haven't seen anything yet.

--
Jeff Trout <[EMAIL PROTECTED]>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/




---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to