Re: Functions

thank you it's helpfull

On Fri, May 8, 2015 at 7:43 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 05/08/2015 01:56 AM, Ramesh T wrote:
>
>> Hi All,
>> I want move functions from onedatabase to other database in same host
>> on windows 7 and installed postgres version is 9.4.I'm using pgadmin3
>> tool.
>> any help..?
>>
>>
> Two options with pgAdmin:
>
> 1) See here
> http://www.pgadmin.org/docs/1.20/backup.html
> http://www.pgadmin.org/docs/1.20/restore.html
> See the Objects pane for selective restore
>
> 2) Go through the tree of objects in the object browser and cut and paste
> the function scripts.
>
> Best option is to create object(tables, functions, etc) definition scripts
> outside your database in text files so you can point them at any database
> you want. Ideally they will be in a version control system.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>