3

I have created some user defined aggregate functions. However, I cannot see a way to export them in pgAdmin. Or any other way.

I can see the underlying functions, but not the CREATE AGGREGATE definitions.

SquirrelSQL doesn't show anything useful either!

Improve this question

1 Answer 1

Reset to default
3

Most probably you need to enable the display of aggregates in your Options:
File -> Options -> Browser -> Display

After refreshing the view you get a separate node Aggregates in the object browser:

Aggreagate node in object browser

The reverse engineered CREATE script for the selected aggregate is displayed to the right in the SQL pane.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

@w͏̢in̡͢g͘̕ed̨p̢͟a͞n͏͏t̡͜͝he̸r̴: I added another answer over there.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.