Lists: | pgsql-general |
---|
From: | Adrian Schreyer <ams214(at)cam(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Dumping schemas using pg_dump without extensions (9.1 Beta) |
Date: | 2011-05-24 08:29:21 |
Message-ID: | BANLkTimbzy4xiKr=Gk2zT8o0VK2u4qsk8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
I am trying to backup a single schema only, without any other database
objects such as extensions. pg_dump however always includes
extensions, even with the --schema=schema option specified (see below
for example). Is there a workaround for this?
Cheers,
Adrian
--
-- TOC entry 20 (class 3079 OID 11673)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- TOC entry 2978 (class 0 OID 0)
-- Dependencies: 20
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
--
-- TOC entry 19 (class 3079 OID 35645)
-- Name: adminpack; Type: EXTENSION; Schema: -; Owner: -
--
CREATE EXTENSION IF NOT EXISTS adminpack WITH SCHEMA pg_catalog;
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Adrian Schreyer <ams214(at)cam(dot)ac(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dumping schemas using pg_dump without extensions (9.1 Beta) |
Date: | 2011-05-25 20:28:47 |
Message-ID: | 26790.1306355327@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Adrian Schreyer <ams214(at)cam(dot)ac(dot)uk> writes:
> I am trying to backup a single schema only, without any other database
> objects such as extensions. pg_dump however always includes
> extensions, even with the --schema=schema option specified (see below
> for example). Is there a workaround for this?
I've applied a patch to fix this behavior. Thanks for the report!
regards, tom lane