Re: Flattening a kind of 'dynamic' table

From: Joe Conway <mail(at)joeconway(dot)com>
To: Alexandre Leclerc <alexandre(dot)leclerc(at)gmail(dot)com>
Cc: Dawid Kuroczko <qnex42(at)gmail(dot)com>, PERFORM <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Flattening a kind of 'dynamic' table
Date: 2005-01-28 18:24:37
Message-ID: 41FA8365.9080602@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Alexandre Leclerc wrote:
> I'm a little bit confused on how to install this contirb. I know my
> contrib package is installed, but I don't know how to make it work in
> postgresql. (Using 7.4.5-1mdk on Mandrake Linux.)
>

Find the file tablefunc.sql and redirect it into your database, e.g.

psql mydatabase < /path/to/contrib/scripts/tablefunc.sql

I have no idea where that would be on Mandrake, but you could probably do:

locate tablefunc.sql

On Fedora Core 1 I find it here:
/usr/share/pgsql/contrib/tablefunc.sql

Also find and read README.tablefunc.

HTH,

Joe

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pallav Kalva 2005-01-28 18:38:15 Re: Poor Performance on Postgres 8.0
Previous Message Alexandre Leclerc 2005-01-28 18:15:44 Re: Flattening a kind of 'dynamic' table