导出“创建聚合" PostgreSQL中的函数 [英] Export "Create Aggregate" functions from PostgreSQL

问题描述

我已经创建了一些用户定义的聚合函数.但是，我看不到在pgAdmin中导出它们的方法.或其他任何方式.

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

我可以看到基本功能，但看不到CREATE AGGREGATE定义.

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

SquirrelSQL也没有显示任何有用的信息！

SquirrelSQL doesn't show anything useful either!

推荐答案

很可能您需要在选项"中启用聚合的显示:
文件->选项->浏览器->显示

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

刷新视图后，您将在对象浏览器中获得一个单独的节点Aggregates:

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

在SQL窗格的右侧，显示了所选聚合的反向工程CREATE脚本.

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

这篇关于导出“创建聚合" PostgreSQL中的函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！