Hi All;

I know part of the function name "get_registration_auth" (this part of its name) while its name might be "voipdb_get_registration_auth_gnugk", how can I search for the functions that its name contain "get_registration_auth"?

Also if I donot know if "get_registration_auth" if a function or view or store procedure, but I am sure there is a table or function or view or store procedure which contain this name, so how can I find it?

Actually this to be from the Linux CLI (I am using fedora) and not from the GUI.

- By the way: Does Postgresql has GUI? How to get it?

Regards
Bilal




--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

bilal ghayyad <bilmar_gh [at] yahoo.com> wrote:

> I know part of the function name "get_registration_auth" (this part
> of its name) while its name might be
> "voipdb_get_registration_auth_gnugk", how can I search for the
> functions that its name contain "get_registration_auth"?

From within psql you can type:

\df *get_registration_auth*

> Also if I donot know if "get_registration_auth" if a function or
> view or store procedure, but I am sure there is a table or function
> or view or store procedure which contain this name, so how can I
> find it?

I would probably just do \d and \df for it.

> - By the way: Does Postgresql has GUI? How to get it?

This is a frequently asked question. Follow the link from the FAQ:

http://wiki.postgresql.org/wiki/FAQ#Does_PostgreSQL_have_a_g raphical_user_interface.3F

It might not hurt to scan the FAQ to help you get started.

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin