You might find Aquameta's meta module helpful, it reimplements
information_schema in a more normalized layout, as updatable views:
http://blog.aquameta.com/2015/08/29/intro-meta/
https://github.com/aquametalabs/aquameta/tree/master/core/000-meta
Best,
Eric
On Mon, Feb 12, 2018 at 2:02 PM Thiemo
"David G. Johnston" writes:
> Unless our docs are completely misleading I'd say that PostgreSQL is being
> conforming while MariaDB is treating information_schema as their version of
> pg_catalog (or at least our system views over top of pg_catalog).
Our project policy is that information_schema
On Tue, Feb 13, 2018 at 4:17 PM, Peter J. Holzer wrote:
>
> It is possible that all the columns that PostgreSQL has are required by
> the standard and that MariaDB is non-conforming by omitting them, but at
> least some of the names look quite PostgreSQL-specific to me. So my
> guess is that the
On 2018-02-13 16:06:43 -0700, David G. Johnston wrote:
> On Tue, Feb 13, 2018 at 3:57 PM, Peter J. Holzer wrote:
>
> (That said, it looks like both PostgreSQL and MariaDB include additional
> columns beyond those mandated by the standard - you can't rely on those,
> of course. And som
On Tue, Feb 13, 2018 at 3:57 PM, Peter J. Holzer wrote:
> (That said, it looks like both PostgreSQL and MariaDB include additional
> columns beyond those mandated by the standard - you can't rely on those,
> of course. And some databases like Oracle don't even have an information
> schema.)
>
G
On 2018-02-12 23:01:41 +0100, Thiemo Kellner wrote:
> I try to implement SCD2 on trigger level and try to generated needed code on
> the fly. Therefore I need to read data about the objects in the database. So
> far so good. I know of the information_schema and the pg_catalog. The
> documentation f
Thiemo Kellner writes:
> I try to implement SCD2 on trigger level and try to generated needed
> code on the fly. Therefore I need to read data about the objects in the
> database. So far so good. I know of the information_schema and the
> pg_catalog. The documentation for the information_schema
I try to implement SCD2 on trigger level and try to generated needed
code on the fly. Therefore I need to read data about the objects in the
database. So far so good. I know of the information_schema and the
pg_catalog. The documentation for the information_schema states that it
'is defined in