| From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
|---|---|
| To: | "Luca Ferrari" <fluca1978(at)infinito(dot)it> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: schema synchronization |
| Date: | 2006-11-13 13:20:31 |
| Message-ID: | bf54be870611130520l3b7060bn84b771d5ca0898fe@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Slony might help you there with the EXECUTE SCRIPT option.
Thanks,
---------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 11/13/06, Luca Ferrari <fluca1978(at)infinito(dot)it> wrote:
>
> Hi all,
> I've got a productional database that is running, while on my laptop I use
> a
> copy of the database to develop an application. Sometimes I have to change
> the schema of the database in order to implement new application features,
> and I'd like to know if there's a way to automatically synchronize the
> schema
> of my laptop (latest) with the productional one. Of course, the changes I
> made does not affect primary or foreign keys or other constraints (i.e., I
> add a column, ...).
> Is this possible?
>
> Thanks,
> Luca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Rihtar | 2006-11-13 13:20:55 | SQL - update table problem... |
| Previous Message | Luca Ferrari | 2006-11-13 13:09:58 | schema synchronization |