Обсуждение: How to view the code of a function

Поиск
Список
Период
Сортировка

How to view the code of a function

От
Venkateswara Rao Bondada
Дата:

Hi,

I’m trying to look at the source code of a function in PostgreSQL. Could anybody please let me know how to view the same?

 

Thanks,

Venkat

 

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are not 
to copy, disclose, or distribute this e-mail or its contents to any other person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken 
every reasonable precaution to minimize this risk, but is not liable for any damage 
you may sustain as a result of any virus in this e-mail. You should carry out your 
own virus checks before opening the e-mail or attachment. Infosys reserves the 
right to monitor and review the content of all messages sent to or from this e-mail 
address. Messages sent to or from this e-mail address may be stored on the 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Re: How to view the code of a function

От
Thomas Kellerer
Дата:
Venkateswara Rao Bondada, 11.12.2009 10:58:
> I’m trying to look at the source code of a function in PostgreSQL. Could
> anybody please let me know how to view the same?
>

select pg_catalog.pg_get_functiondef(oid)
from pg_proc

http://www.postgresql.org/docs/current/static/functions-info.html


As an alternative use a GUI tool that does this for you
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

Thomas

Re: How to view the code of a function

От
Sam Jas
Дата:
(1) select procsrc from pg_proc where proname like '<function_name>';

(2) df+ <function_name>



--
Thanks
Sam Jas




--- On Fri, 11/12/09, Venkateswara Rao Bondada <Venkateswara_B@infosys.com> wrote:

From: Venkateswara Rao Bondada <Venkateswara_B@infosys.com>
Subject: [ADMIN] How to view the code of a function
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Friday, 11 December, 2009, 9:58 AM

Hi,

I’m trying to look at the source code of a function in PostgreSQL. Could anybody please let me know how to view the same?

 

Thanks,

Venkat

 

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are not
to copy, disclose, or distribute this e-mail or its contents to any other person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
every reasonable precaution to minimize this risk, but is not liable for any damage
you may sustain as a result of any virus in this e-mail. You should carry out your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this e-mail
address. Messages sent to or from this e-mail address may be stored onthe
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.

Re: How to view the code of a function

От
Ashish Karalkar
Дата:
On 12/11/2009 03:28 PM, Venkateswara Rao Bondada wrote:

Hi,

I’m trying to look at the source code of a function in PostgreSQL. Could anybody please let me know how to view the same?

 

Thanks,

Venkat

 

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are not 
to copy, disclose, or distribute this e-mail or its contents to any other person and 
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken 
every reasonable precaution to minimize this risk, but is not liable for any damage 
you may sustain as a result of any virus in this e-mail. You should carry out your 
own virus checks before opening the e-mail or attachment. Infosys reserves the 
right to monitor and review the content of all messages sent to or from this e-mail 
address. Messages sent to or from this e-mail address may be stored on the 
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***


\df+ funcation_name();

--Ashish

Looking for Good and Easy-to-use Reporting Tool

От
"Su, Alan"
Дата:

Can anyone recommend a good, easy to ease and inexpensive reporting tool for accessing and manipulating Postgre database/table? The key features I am looking for with this tool are as follows:

 

  • Require less programming effort. I am trying to stay away from having to write sophisticate programming language, such as Java or .Net
  • Allow to bundle SQL commands in store procedure like style.
  • Allow to evaluate conditions of SQL result set and trigger alert email based on preset threshold.

 

 

Thanks.

Alan


This email and all files and information transmitted with it are confidential and intended solely for the use of the individual or entity to whom the email is addressed. If you are not the intended recipient or the person responsible for delivering the email to the intended recipient(s), you have received this email in error, and use of it is strictly prohibited. Opinions expressed herein are those of the individual sender and not of the company unless specifically so indicated. If you have received this communication in error, please immediately notify the sender, delete this message, and do not print, copy, or disclose the content of this message. Inadvertent disclosure of this message does not waive any privilege or claim of confidentiality.

For important conflict disclosures, please visit http://www.daiwausa.com/report_disclosure.html

If your settings do not permit you to access this link directly, please use your internet browser to visit this website address.

Re: Looking for Good and Easy-to-use Reporting Tool

От
Brian Modra
Дата:
2009/12/11 Su, Alan <Alan.Su@daiwausa.com>:
> Can anyone recommend a good, easy to ease and inexpensive reporting tool for
> accessing and manipulating Postgre database/table? The key features I am
> looking for with this tool are as follows:
>
>
>
> Require less programming effort. I am trying to stay away from having to
> write sophisticate programming language, such as Java or .Net
> Allow to bundle SQL commands in store procedure like style.
> Allow to evaluate conditions of SQL result set and trigger alert email based
> on preset threshold.


Have you seen this:
http://www.zwartberg.com/surf.html

You can write SQLs or calls to PLPGSQL (stored procedure) directly
into the XML configuration file, then generate a web front end. No
Java or C++ required, though you can make complex features in C++. But
for more complex GUI logic, you'll need Javascript. There is no
escaping writing programs to describe logic, but the straight-forward
front-end is all auto-generated from your XML configuration and HTML.

To do email from triggers will require extra coding, but talk to me about it...

The Karoo Project is new, and the documentation is a bit lacking, but
you can email me your questions "Brian Modra" <brian@zwartberg.com>

>
>
> Thanks.
>
> Alan
>
> This email and all files and information transmitted with it are
> confidential and intended solely for the use of the individual or entity to
> whom the email is addressed. If you are not the intended recipient or the
> person responsible for delivering the email to the intended recipient(s),
> you have received this email in error, and use of it is strictly prohibited.
> Opinions expressed herein are those of the individual sender and not of the
> company unless specifically so indicated. If you have received this
> communication in error, please immediately notify the sender, delete this
> message, and do not print, copy, or disclose the content of this message.
> Inadvertent disclosure of this message does not waive any privilege or claim
> of confidentiality.
>
> For important conflict disclosures, please visit
> http://www.daiwausa.com/report_disclosure.html
>
> If your settings do not permit you to access this link directly, please use
> your internet browser to visit this website address.
>



--
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

Re: Looking for Good and Easy-to-use Reporting Tool

От
"Su, Alan"
Дата:
Brian,

What you mentioned below is more sophisticated than what I am capable of doing now. Could you or anyone on this email
recommendother tool that meets the following requirements:  

1. Require less programming effort. I am trying to stay away from having to
write sophisticate programming language, such as Java or .Net
2. Allow to bundle SQL commands in store procedure like style.
3. Allow to evaluate conditions of SQL result set and trigger alert email based
on a preset threshold.


-----Original Message-----
From: Brian Modra [mailto:epailty@googlemail.com]
Sent: Friday, December 11, 2009 3:09 PM
To: Su, Alan
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009/12/11 Su, Alan <Alan.Su@daiwausa.com>:
> Can anyone recommend a good, easy to ease and inexpensive reporting tool for
> accessing and manipulating Postgre database/table? The key features I am
> looking for with this tool are as follows:
>
>
>
> Require less programming effort. I am trying to stay away from having to
> write sophisticate programming language, such as Java or .Net
> Allow to bundle SQL commands in store procedure like style.
> Allow to evaluate conditions of SQL result set and trigger alert email based
> on preset threshold.


Have you seen this:
http://www.zwartberg.com/surf.html

You can write SQLs or calls to PLPGSQL (stored procedure) directly
into the XML configuration file, then generate a web front end. No
Java or C++ required, though you can make complex features in C++. But
for more complex GUI logic, you'll need Javascript. There is no
escaping writing programs to describe logic, but the straight-forward
front-end is all auto-generated from your XML configuration and HTML.

To do email from triggers will require extra coding, but talk to me about it...

The Karoo Project is new, and the documentation is a bit lacking, but
you can email me your questions "Brian Modra" <brian@zwartberg.com>

>
>
> Thanks.
>
> Alan
>
> This email and all files and information transmitted with it are
> confidential and intended solely for the use of the individual or entity to
> whom the email is addressed. If you are not the intended recipient or the
> person responsible for delivering the email to the intended recipient(s),
> you have received this email in error, and use of it is strictly prohibited.
> Opinions expressed herein are those of the individual sender and not of the
> company unless specifically so indicated. If you have received this
> communication in error, please immediately notify the sender, delete this
> message, and do not print, copy, or disclose the content of this message.
> Inadvertent disclosure of this message does not waive any privilege or claim
> of confidentiality.
>
> For important conflict disclosures, please visit
> http://www.daiwausa.com/report_disclosure.html
>
> If your settings do not permit you to access this link directly, please use
> your internet browser to visit this website address.
>



--
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

This email and all files and information transmitted with it are confidential and intended solely for the use of the
individualor entity to whom the email is addressed.  If you are not the intended recipient or the person responsible
fordelivering the email to the intended recipient(s), you have received this email in error, and use of it is strictly
prohibited. Opinions expressed herein are those of the individual sender and not of the company unless specifically so
indicated. If you have received this communication in error, please immediately notify the sender, delete this message,
anddo not print, copy, or disclose the content of this message.  Inadvertent disclosure of this message does not waive
anyprivilege or claim of confidentiality. 

For important conflict disclosures, please visit http://www.daiwausa.com/report_disclosure.html

If your settings do not permit you to access this link directly, please use your internet browser to visit this website
address.

Re: Looking for Good and Easy-to-use Reporting Tool

От
"Kevin Grittner"
Дата:
"Su, Alan" <Alan.Su@daiwausa.com> wrote:

> 1. Require less programming effort. I am trying to stay away from
> having to write sophisticate programming language, such as Java or
> .Net
> 2. Allow to bundle SQL commands in store procedure like style.
> 3. Allow to evaluate conditions of SQL result set and trigger
> alert email based on a preset threshold.

Have you considered psql and grep, with maybe a little logic in bash?

-Kevin

Re: Looking for Good and Easy-to-use Reporting Tool

От
Brian Modra
Дата:
2009/12/15 Su, Alan <Alan.Su@daiwausa.com>:
> Brian,
>
> What you mentioned below is more sophisticated than what I am capable of doing now. Could you or anyone on this email
recommendother tool that meets the following requirements: 
>
> 1. Require less programming effort. I am trying to stay away from having to
> write sophisticate programming language, such as Java or .Net
> 2. Allow to bundle SQL commands in store procedure like style.
> 3. Allow to evaluate conditions of SQL result set and trigger alert email based
> on a preset threshold.

Please describe the application in more detail. Do you need any sort
of GUI front end to the application?
Or is it just reporting via email?

>
>
> -----Original Message-----
> From: Brian Modra [mailto:epailty@googlemail.com]
> Sent: Friday, December 11, 2009 3:09 PM
> To: Su, Alan
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool
>
> 2009/12/11 Su, Alan <Alan.Su@daiwausa.com>:
>> Can anyone recommend a good, easy to ease and inexpensive reporting tool for
>> accessing and manipulating Postgre database/table? The key features I am
>> looking for with this tool are as follows:
>>
>>
>>
>> Require less programming effort. I am trying to stay away from having to
>> write sophisticate programming language, such as Java or .Net
>> Allow to bundle SQL commands in store procedure like style.
>> Allow to evaluate conditions of SQL result set and trigger alert email based
>> on preset threshold.
>
>
> Have you seen this:
> http://www.zwartberg.com/surf.html
>
> You can write SQLs or calls to PLPGSQL (stored procedure) directly
> into the XML configuration file, then generate a web front end. No
> Java or C++ required, though you can make complex features in C++. But
> for more complex GUI logic, you'll need Javascript. There is no
> escaping writing programs to describe logic, but the straight-forward
> front-end is all auto-generated from your XML configuration and HTML.
>
> To do email from triggers will require extra coding, but talk to me about it...
>
> The Karoo Project is new, and the documentation is a bit lacking, but
> you can email me your questions "Brian Modra" <brian@zwartberg.com>
>
>>
>>
>> Thanks.
>>
>> Alan
>>
>> This email and all files and information transmitted with it are
>> confidential and intended solely for the use of the individual or entity to
>> whom the email is addressed. If you are not the intended recipient or the
>> person responsible for delivering the email to the intended recipient(s),
>> you have received this email in error, and use of it is strictly prohibited.
>> Opinions expressed herein are those of the individual sender and not of the
>> company unless specifically so indicated. If you have received this
>> communication in error, please immediately notify the sender, delete this
>> message, and do not print, copy, or disclose the content of this message.
>> Inadvertent disclosure of this message does not waive any privilege or claim
>> of confidentiality.
>>
>> For important conflict disclosures, please visit
>> http://www.daiwausa.com/report_disclosure.html
>>
>> If your settings do not permit you to access this link directly, please use
>> your internet browser to visit this website address.
>>
>
>
>
> --
> Brian Modra   Land line: +27 23 5411 462
> Mobile: +27 79 69 77 082
> 5 Jan Louw Str, Prince Albert, 6930
> Postal: P.O. Box 2, Prince Albert 6930
> South Africa
> http://www.zwartberg.com/
>
> This email and all files and information transmitted with it are confidential and intended solely for the use of the
individualor entity to whom the email is addressed.  If you are not the intended recipient or the person responsible
fordelivering the email to the intended recipient(s), you have received this email in error, and use of it is strictly
prohibited. Opinions expressed herein are those of the individual sender and not of the company unless specifically so
indicated. If you have received this communication in error, please immediately notify the sender, delete this message,
anddo not print, copy, or disclose the content of this message.  Inadvertent disclosure of this message does not waive
anyprivilege or claim of confidentiality. 
>
> For important conflict disclosures, please visit http://www.daiwausa.com/report_disclosure.html
>
> If your settings do not permit you to access this link directly, please use your internet browser to visit this
websiteaddress. 
>



--
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/