CODEWITHSUNDEEP
postgresqlaggregate-functionspgadmin
Codek
Codek

Reputation: 5164

Export "Create Aggregate" functions from PostgreSQL

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!

Upvotes: 3

Views: 1170

Answers (1)

Erwin Brandstetter
Erwin Brandstetter

Reputation: 658112

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.

Upvotes: 3

Related Questions