Pg newbie here, first time I'm reading about this. Super useful for internal tools indeed!

Could you point me to any tools or resources on achieving that (pulling data from several external databases into a single one for the purpose of analytics/aggregation)?