search

jtornero / pivotmytable

PivotMyTable is a PL/Python PosgreSQL function for easy construction of pivot tables, generating the proper code for the crosstab functions from the PostgreSQL extension tablefunc to work.
GNU General Public License v3.0
16 stars 9 forks source link

Allow materialized views as input table to pivot #5

Closed JohnDeGitt closed 9 years ago

JohnDeGitt commented 9 years ago

Use pg_attribute (Postgresql catalog table) instead of information_schema to get metadata on Postgresql relations. It is faster and contains details about all relations: tables, views and materialized views. Closes #4.

Use current_schema() as a relation name prefix to make sure that it refers current schema (the same names can exist in different schemas).

jtornero commented 9 years ago

@JohnDeGitt #4 Closed. Thank you very much @JohnDeGitt

JohnDeGitt commented 9 years ago

It was a pleasure to help to improve your script. Regards, John