Обсуждение: FUNCTION DEFINITION
Hi, If I have created a plpgsql function, is there a way I can look again at the create statement of that function. I need to know what exactly is there in the function. Thanks Abhang
ABHANG RANE wrote: > Hi, > If I have created a plpgsql function, is there a way I can look again at > the create statement of that function. I need to know what exactly is > there in the function. select * from pg_proc where proname = 'foo' or \df+ function_name > > Thanks > Abhang > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
ABHANG RANE wrote: > Hi, > If I have created a plpgsql function, is there a way I can look again at > the create statement of that function. I need to know what exactly is > there in the function. From psql: \df+ my_function From command-line: pg_dump --schema-only my_database > my_db_dump.sql Second one is easier to scroll through/edit. -- Richard Huxton Archonet Ltd