is there a way to dump the version of extensions - Mailing list pgsql-general

From Manuel Kniep
Subject is there a way to dump the version of extensions
Date
Msg-id A882C5D3-589B-47DD-B133-4E36135D32AA@adjust.com
Whole thread Raw
Responses Re: is there a way to dump the version of extensions  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Hi,

when doing a pg_dump on postgres 9.2 the resulting sql file only has

CREATE EXTENSION extension_name;

I would like to include the specific version of the extension to make sure that the correct version
is installed when loading the dump like


CREATE EXTENSION extension_name VERSION vesion;

Is there a way to do that?

cheers

Manuel

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Auditing Code - Fortify
Next
From: Frank
Date:
Subject: Re: Is it possible to "pip" pg_dump output into new db ?