Planet PostgreSQL

Planet PostgreSQL -

Hubert 'depesz' Lubaczewski: How to get a row, and all of it’s dependencies?

This question was asked at least twice on some support channel. Getting a row is trivial: select * from table where id = ?. But what about dependencies – the rows that this exported row references? Decided to take a look at this task. First of all, returning data from/about multiple tables will be tricky. … Continue reading "How to get a row, and all of it’s dependencies?"

通过创建函数export_row、get_row_data和export_data,可以实现从多个表中导出数据,并且可以跟踪单列的外键,可以下载所有函数文件,使用起来方便快捷。

相关推荐 去reddit讨论

热榜 Top10

Dify.AI
Dify.AI
LigaAI
LigaAI
eolink
eolink
观测云
观测云

推荐或自荐