From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
---|---|
To: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
Cc: | stefan(dot)schwarzer(at)unep(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to include Tablefunc as an extension |
Date: | 2012-06-18 14:48:22 |
Message-ID: | CAKt_Zfvb8Xq4_7bLezMS5VUmVcNOO5GChUN+vixXeZ=0nKqDEg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jun 18, 2012 at 7:36 AM, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:
> On 18 Červen 2012, 16:29, Stefan Schwarzer wrote:
>> Hello,
>>
>>
>>
>> I read through the Postgres doc and many Google results, but it seems
>> still unclear to me how to include additional packages into my postgres
>> database. I see that there are a few installed under
>> "/usr/local/pgsql-9.1/share/extension/" (I am on Lion and installed the
>> Kyngchaos libs). But as I want to install crosstab now, I downloaded the
>> source code for postgres, run a make/install - and now wonder what to do
>> with it. I could eventually load the .sql file as usual; but it seems this
>> should be now avoided, and loaded as an extension. I tried to copy three
>> files (--1.0.sql, --unpackaged.sql and the normal .sql) to the folder and
>> then load it from PgAdmin, but this results in an error message ("could
>> not access file "$libdir/tablefunc"").
>
CREATE EXTENSION tablefunc;
(we use connectby() in LedgerSMB 1.3)
Best Wishes,
Chris Travers
From | Date | Subject | |
---|---|---|---|
Next Message | vmkurz | 2012-06-18 15:17:46 | Examples of "dblink_build_sql_update" |
Previous Message | Tomas Vondra | 2012-06-18 14:36:59 | Re: How to include Tablefunc as an extension |