[GTALUG] looking for a tool to transform table relationships

[D. Hugh Redelmeier]

| From: Alex Volkov via talk <talk at gtalug.org>

| On 2018-07-20 03:35 PM, D. Hugh Redelmeier via talk wrote:

| > Super naive question:

I should disclose just how naive.  I've essentially never used SQL.
OK, perhaps a query or two when puzzled by MythTV.

| > Could you not do this transformation in SQL?
| 
| Yes, now as I've done a bit more research just doing SQL with dblink might be
| the way to go. The thing I don't like is SQL for text transformation can be
| pretty awkward.

Surely there is ssome way to use these functions
<https://www.postgresql.org/docs/9.4/static/functions-string.html>

Or PL/psSQL or PL/python or PL/java etc.