| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Ramesh T <rameshparnanditech(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Functions |
| Date: | 2015-05-08 14:13:13 |
| Message-ID: | 554CC479.5090102@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2015-05-08 14:35:15 | Re: Block Corruption issue.. |
| Previous Message | Ramesh T | 2015-05-08 08:56:38 | Functions |