is there a way to dump the version of extensions

From: Manuel Kniep <manuel(at)adjust(dot)com>
To: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: is there a way to dump the version of extensions
Date: 2014-03-27 10:11:45
Message-ID: A882C5D3-589B-47DD-B133-4E36135D32AA@adjust.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Khangelani Gama 2014-03-27 10:16:32 Synchronizing a table that is two different databases : Need to dump a table a insert from db1 and change the insert statements into UPDATE statements
Previous Message Dev Kumkar 2014-03-27 08:15:11 Re: Auditing Code - Fortify