Can somebody tell me how Stored Functions are kept in the database? I've
gone through the catalog several times. I've found many interesting
things but NOT the 300-odd functions I've created.
Rick
--
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly 5 2433
On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote: Can somebody tell me how Stored Functions are kept in the database? I've gone through the catalog several times. I've found many interesting things but NOT the 300-odd functions I've created. Rick
\df
--
Martijn van Oosterhout <kl*****@svana. org> http://svana.org/kleptog/ "All that is needed for the forces of evil to triumph is for enough good men to do nothing." - Edmond Burke "The penalty good people pay for not being interested in politics is to be governed by people worse than themselves." - Plato
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE/0PpYY5Twig3Ge+Y RAml5AKDL+DZ584 GfNR+OTpEGYc/ZR5fgsQCcDj/2
NjC03GEeK7Dbe5Y W6gU2bsA=
=FU84
-----END PGP SIGNATURE-----
Thanks for the psql response.
But, I seldom use psql. I find PG Manager much more useful. Even PG
Admin was better.
I am looking to write some stored functions to query the database to
automatically create the repotrs I now generate by hand.
So I was trying to find my Stored Functions in the database so I could
query them.
Rick
Martijn van Oosterhout wrote: On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote:
Can somebody tell me how Stored Functions are kept in the database? I've gone through the catalog several times. I've found many interesting things but NOT the 300-odd functions I've created.
Rick
\df
--
------------------------------------------------------------------------
A Message from MicroPatent® LLC
MicroPatent now offers searchable .PDF patents! Save time and improve your workflow efficiencies with these convenient, easy-to-review documents. For more information, go to http://www.micropat.com/0/searchable...hable_pdf.html.
Richard Hall
Database Programmer
MicroPatent LLC
250 Dodge Avenue
East Haven, CT 06512
T: <Phone Number>, x 3321
F: <Fax Number>
S: <Toll Free Number> rh***@micropat. com www.micropat.com
MicroPatent is an Information Holdings Inc. company (NYSE: IHI).
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
select * from pg_proc where proname = ''
Sincerely,
Joshua D. Drake
Rich Hall wrote: Thanks for the psql response.
But, I seldom use psql. I find PG Manager much more useful. Even PG Admin was better.
I am looking to write some stored functions to query the database to automatically create the repotrs I now generate by hand. So I was trying to find my Stored Functions in the database so I could query them.
Rick
Martijn van Oosterhout wrote:
On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote:
Can somebody tell me how Stored Functions are kept in the database? I've gone through the catalog several times. I've found many interesting things but NOT the 300-odd functions I've created.
Rick
\df
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Well, using the -E option to psql, \df expands to:
SELECT CASE WHEN p.proretset THEN 'setof ' ELSE '' END ||
pg_catalog.form at_type(p.prore ttype, NULL) as "Result data type",
n.nspname as "Schema",
p.proname as "Name",
pg_catalog.oidv ectortypes(p.pr oargtypes) as "Argument data types"
FROM pg_catalog.pg_p roc p
LEFT JOIN pg_catalog.pg_n amespace n ON n.oid = p.pronamespace
WHERE p.prorettype <> 'pg_catalog.cst ring'::pg_catal og.regtype
AND p.proargtypes[0] <> 'pg_catalog.cst ring'::pg_catal og.regtype
AND NOT p.proisagg
AND pg_catalog.pg_f unction_is_visi ble(p.oid)
ORDER BY 2, 3, 1, 4;
and \df+ expands to
SELECT CASE WHEN p.proretset THEN 'setof ' ELSE '' END ||
pg_catalog.form at_type(p.prore ttype, NULL) as "Result data type",
n.nspname as "Schema",
p.proname as "Name",
pg_catalog.oidv ectortypes(p.pr oargtypes) as "Argument data types",
u.usename as "Owner",
l.lanname as "Language",
p.prosrc as "Source code",
pg_catalog.obj_ description(p.o id, 'pg_proc') as "Descriptio n"
FROM pg_catalog.pg_p roc p
LEFT JOIN pg_catalog.pg_n amespace n ON n.oid = p.pronamespace
LEFT JOIN pg_catalog.pg_l anguage l ON l.oid = p.prolang
LEFT JOIN pg_catalog.pg_u ser u ON u.usesysid = p.proowner
WHERE p.prorettype <> 'pg_catalog.cst ring'::pg_catal og.regtype
AND p.proargtypes[0] <> 'pg_catalog.cst ring'::pg_catal og.regtype
AND NOT p.proisagg
AND pg_catalog.pg_f unction_is_visi ble(p.oid)
ORDER BY 2, 3, 1, 4;
So it looks like pg_proc might be your best bet.
Hope this helps,
On Fri, Dec 05, 2003 at 05:59:11PM -0500, Rich Hall wrote: Thanks for the psql response. But, I seldom use psql. I find PG Manager much more useful. Even PG Admin was better. I am looking to write some stored functions to query the database to automatically create the repotrs I now generate by hand. So I was trying to find my Stored Functions in the database so I could query them. Rick Martijn van Oosterhout wrote: On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote:
Can somebody tell me how Stored Functions are kept in the database? I've gone through the catalog several times. I've found many interesting things but NOT the 300-odd functions I've created.
Rick
\df
-- ------------------------------------------------------------------------ A Message from MicroPatent® LLC MicroPatent now offers searchable .PDF patents! Save time and improve your workflow efficiencies with these convenient, easy-to-review documents. For more information, go to http://www.micropat.com/0/searchable...hable_pdf.html. Richard Hall Database Programmer MicroPatent LLC 250 Dodge Avenue East Haven, CT 06512 T: <Phone Number>, x 3321 F: <Fax Number> S: <Toll Free Number> rh***@micropat. com www.micropat.com MicroPatent is an Information Holdings Inc. company (NYSE: IHI). ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
--
Martijn van Oosterhout <kl*****@svana. org> http://svana.org/kleptog/ "All that is needed for the forces of evil to triumph is for enough good men to do nothing." - Edmond Burke "The penalty good people pay for not being interested in politics is to be governed by people worse than themselves." - Plato
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE/0RNZY5Twig3Ge+Y RAjNOAJ49qjznxc y0MWF9/sUPVYYNb9arIgCf WDM8
/DNQWsYSGBbVYPuO Xu0iijc=
=p/jg
-----END PGP SIGNATURE-----
Thats most of what I needed. I shouls be able to suss out the rest.
Thanks
Rick
Martijn van Oosterhout wrote: Well, using the -E option to psql, \df expands to:
SELECT CASE WHEN p.proretset THEN 'setof ' ELSE '' END || pg_catalog.form at_type(p.prore ttype, NULL) as "Result data type", n.nspname as "Schema", p.proname as "Name", pg_catalog.oidv ectortypes(p.pr oargtypes) as "Argument data types" FROM pg_catalog.pg_p roc p LEFT JOIN pg_catalog.pg_n amespace n ON n.oid = p.pronamespace WHERE p.prorettype <> 'pg_catalog.cst ring'::pg_catal og.regtype AND p.proargtypes[0] <> 'pg_catalog.cst ring'::pg_catal og.regtype AND NOT p.proisagg AND pg_catalog.pg_f unction_is_visi ble(p.oid) ORDER BY 2, 3, 1, 4;
and \df+ expands to
SELECT CASE WHEN p.proretset THEN 'setof ' ELSE '' END || pg_catalog.form at_type(p.prore ttype, NULL) as "Result data type", n.nspname as "Schema", p.proname as "Name", pg_catalog.oidv ectortypes(p.pr oargtypes) as "Argument data types", u.usename as "Owner", l.lanname as "Language", p.prosrc as "Source code", pg_catalog.obj_ description(p.o id, 'pg_proc') as "Descriptio n" FROM pg_catalog.pg_p roc p LEFT JOIN pg_catalog.pg_n amespace n ON n.oid = p.pronamespace LEFT JOIN pg_catalog.pg_l anguage l ON l.oid = p.prolang LEFT JOIN pg_catalog.pg_u ser u ON u.usesysid = p.proowner WHERE p.prorettype <> 'pg_catalog.cst ring'::pg_catal og.regtype AND p.proargtypes[0] <> 'pg_catalog.cst ring'::pg_catal og.regtype AND NOT p.proisagg AND pg_catalog.pg_f unction_is_visi ble(p.oid) ORDER BY 2, 3, 1, 4;
So it looks like pg_proc might be your best bet.
Hope this helps,
On Fri, Dec 05, 2003 at 05:59:11PM -0500, Rich Hall wrote:
Thanks for the psql response.
But, I seldom use psql. I find PG Manager much more useful. Even PG Admin was better.
I am looking to write some stored functions to query the database to automatical ly create the repotrs I now generate by hand. So I was trying to find my Stored Functions in the database so I could query them.
Rick
Martijn van Oosterhout wrote: On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote:
Can somebody tell me how Stored Functions are kept in the database? I've gone through the catalog several times. I've found many interesting things but NOT the 300-odd functions I've created.
Rick
\df
-- ------------------------------------------------------------------------ A Message from MicroPatent® LLC
MicroPatent now offers searchable .PDF patents! Save time and improve your workflow efficiencies with these convenient, easy-to-review documents. For more information, go to http://www.micropat.com/0/searchable...hable_pdf.html.
Richard Hall Database Programmer MicroPatent LLC 250 Dodge Avenue East Haven, CT 06512 T: <Phone Number>, x 3321 F: <Fax Number> S: <Toll Free Number> rh***@micropa t.com www.micropat.com
MicroPatent is an Information Holdings Inc. company (NYSE: IHI). ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
--
------------------------------------------------------------------------
A Message from MicroPatent® LLC
MicroPatent now offers searchable .PDF patents! Save time and improve your workflow efficiencies with these convenient, easy-to-review documents. For more information, go to http://www.micropat.com/0/searchable...hable_pdf.html.
Richard Hall
Database Programmer
MicroPatent LLC
250 Dodge Avenue
East Haven, CT 06512
T: <Phone Number>, x 3321
F: <Fax Number>
S: <Toll Free Number> rh***@micropat. com www.micropat.com
MicroPatent is an Information Holdings Inc. company (NYSE: IHI).
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: C Kirby |
last post by:
In SQL Server 2000, I've got a rather lengthy stored procedure, which
creates a lot of temporary tables as it processes down through a few
sets of data.
When testing it through Query Analyzer, it runs fine (a bit slow
though). But when I try to run it through the ade, it doesn't do
anything. It runs through the procedure in milliseconds but doesn't
seem to ever actually start it. If I change the calling code in the
ade VBA to refer to...
|
by: Nashat Wanly |
last post by:
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and
Visual C# .NET
View products that this article applies to.
This article was previously published under Q310070
For a Microsoft Visual Basic .NET version of this article, see 308049.
For a Microsoft Visual C++ .NET version of this article, see 310071.
For a Microsoft Visual J# .NET version of this article, see 320627.
This article refers to the following Microsoft .NET...
|
by: Együd Csaba |
last post by:
Hi,
I've a problem with some of my stored procs. My config is: RH7.1, Postgres
7.3.2
I have converted a few fields of a few tables from one type to another.
After this I made all the necessary changes on the functions and recreated
all my types and functions. (Actually I recreated the whole database later
from a dump.) It seemd to be all right, but some functions won't work
anymore. I call them from a windows client program (Delphi via...
|
by: Tim Marshall |
last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with
interest and on reading the post describing Lauren Quantrell's
SmartTree, I've run into something I don't understand: Stored
Procedures. I thought stored pricedures were an Oracle/MS SQL Server
thing and don't know how they work with Access Jet. I've looked at some
of the help on stored procedures in A2003, but really don't understand
what's going on.
Can someone...
|
by: Mike TI |
last post by:
April 22, 2006
Hi all
I want to execute a command stored in a variable, eg I may store:
Form1.Show()
or
Form2.Show()
| |
by: Jack |
last post by:
Thanks.
|
by: KishorAditya |
last post by:
Hi All,
Consider the following scenario:
class Top { };
class Left: virtual public Top { };
class Right: virtual public Top { };
class Bottom: public Left, public Right {};
Many books propose that object of Bottom contains three vptrs, one for
Left and Bottom, one for Right and one for Top.
Now my question is why the compiler is storing superclasses' vptrs in
|
by: orkonoid |
last post by:
Hello, I am having trouble with a Polymorphism issue using container classes.
I have a longwinded and shortwinded version of my question:
Shortwinded version:
How can I store base class objects in a container class like a vector or list while still being able to access the individual subclass (virtual) functions? In my program, it is as if the functions aren't virtual.
Longwinded version:
|
by: mansi sharma |
last post by:
Functions ia a block of code that performs some task & returns value.
Can somebody tell me What are Stored Procedures?
I found abt Stored procedues from the Net-->Stored Procedures is a group of SQL statements that form a logical unit and perform some task.
Above defintion of Stored procedures is same as functions.
Then What d diference b/w two?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |