Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Show function source?

    This is probably simple but I can't find it in the docs.

    I've created a function and it is working correctly, but how do I view its source? Also, how do I view a trigger's source?

    thanks!

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    function

    ???
    If you have written them look into your source file!!!

    out of postgres you cannot see into a function
    (maybe yes but i'*m not aware of it)
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Nov 2003
    Location
    Poland
    Posts
    7

    Re: Show function source?

    Originally posted by autopilot
    This is probably simple but I can't find it in the docs.

    I've created a function and it is working correctly, but how do I view its source? Also, how do I view a trigger's source?

    thanks!
    go to www.pgexplorer.com get the software, connect to the server pick the procedure , right click on it and choose "Extract SQL", New windows will show up with your source code

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    pgadmin

    If you want to use a feature like this use pgadmin3
    pgadmin.postgresql.org

    It makes the same and it's free
    If pgadmin will be developed further this way it will become the best gui for postgres ever
    You can use it on win/*nix/BSD/MAC
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  5. #5
    Join Date
    Nov 2003
    Posts
    3
    thanks for the tips but that's not what I'm looking for.

    I want to see the function source from within psql. Not running a separate app. It must be possible, how to the gui's get the function source?

  6. #6
    Join Date
    Nov 2003
    Posts
    3
    thanks for the tips but that's not what I'm looking for.

    I want to see the function source from within psql. Not running a separate app. It must be possible, how to the gui's get the function source?

  7. #7
    Join Date
    Oct 2003
    Posts
    33
    \df+ my_function

Posting Permissions

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