Functions question

\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)