Re: [GENERAL] is there a way to dump the version of extensions

2014-03-28 Thread Michael Paquier
On Thu, Mar 27, 2014 at 7:11 PM, Manuel Kniep man...@adjust.com wrote: 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

[GENERAL] is there a way to dump the version of extensions

2014-03-27 Thread Manuel Kniep
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