Обсуждение: Functions question
Hi, Just wondering, is there a way to see a function from within psql? I was looking at the \? command list and found \df but that didn't seem to work. I created a function, ins_news(), and when I typed \df ins_news() it came back and said zero rows. Using pgadmin II on a windows workstation I can see the function I created and the function works so I know it's there but how can I list out the function? There must be a way since it is listed in pgadmin. Thanks in advance, Linn
\df ins_news do not ue the brackets hth On Mon, 19 Aug 2002, Linn Kubler wrote: > Hi, > > Just wondering, is there a way to see a function from within psql? I > was looking at the \? command list and found \df but that didn't seem to > work. I created a function, ins_news(), and when I typed \df ins_news() > it came back and said zero rows. Using pgadmin II on a windows > workstation I can see the function I created and the function works so I > know it's there but how can I list out the function? There must be a > way since it is listed in pgadmin. > > Thanks in advance, > Linn > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Darren Ferguson
"Linn Kubler" <LKubler@ecw.org> writes: > I created a function, ins_news(), and when I typed \df ins_news() > it came back and said zero rows. Try it without the parens: \df ins_news regards, tom lane
Thanks to all who replied. That explains it my function returns opaque, is there another command that will show a function that returns opaque? Thanks, Linn >>> "Ian Harding" <ianh@tpchd.org> 08/19/02 05:26PM >>> \df accepts regular expressions. Try \df ins.* or better yet, \df ins_news Also, \df will not show functions returning opaque. >>> "Linn Kubler" <LKubler@ecw.org> 08/19/02 03:22PM >>> Hi, Just wondering, is there a way to see a function from within psql? I was looking at the \? command list and found \df but that didn't seem to work. I created a function, ins_news(), and when I typed \df ins_news() it came back and said zero rows. Using pgadmin II on a windows workstation I can see the function I created and the function works so I know it's there but how can I list out the function? There must be a way since it is listed in pgadmin. Thanks in advance, Linn ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)