Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: procedure in the db

    Hi,
    I use postgresql in red hat linux .
    I want to know how I can find out what procedure is stored in the current database.
    What sql command I can use to find out these information ??

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    In psql simply type \df
    http://www.postgresql.org/docs/curre.../app-psql.html

    Or use:
    PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: routines
    Code:
    SELECT * FROM information_schema.routines

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •