Advanced Search

Return to Snippet

Revision: 7932
at August 21, 2008 13:42 by mavallad
Initial Code 
-- View functions in postgres
\df
select * from pg_proc where proname = 'myfunction';

-- View code of the function
select prosrc from pg_proc where proname = 'myfunciont';

-- Execute a function
select myfunction(parameters);
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Functions in postgres

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL