Re: [GENERAL] Updating database structure

2006-03-23 Thread Jim Nasby
On Mar 23, 2006, at 9:50 AM, [EMAIL PROTECTED] wrote: I currently use phpPgAdmin to make changes to the database, so it would be very handy if Postgres could add a change made to a lable somewhere, after which I gather all the rows with changes and put them in a SQL query. My suggestion: d

Re: [GENERAL] Updating database structure

2006-03-23 Thread Miroslav Šulc
Hello, I accidentaly came across this post. I didn't follow it so I don't know whether my posting is to the topic or not. I've just uploaded project at SourceForge.Net on topic of PostgreSQL database schema upgrades because I needed to find out differences between current and new schemas. The p

Re: [GENERAL] Updating database structure

2006-03-23 Thread Alban Hertroys
Guido Neitzer wrote: I mostly use the command line tools or a graphical tool to make my own sql calls for every schema change I make on the development database. Then all these changes come to a "script" in my application (it's not actually a script but similar). The database has a version

Re: [GENERAL] Updating database structure

2006-03-23 Thread Guido Neitzer
On 23.03.2006, at 9:50 Uhr, [EMAIL PROTECTED] wrote: I currently use phpPgAdmin to make changes to the database, so it would be very handy if Postgres could add a change made to a lable somewhere, after which I gather all the rows with changes and put them in a SQL query. I mostly use the

Re: [GENERAL] Updating database structure

2006-03-23 Thread subscribe
Quoting Janning Vygen <[EMAIL PROTECTED]>: Am Mittwoch, 22. März 2006 20:40 schrieb Luuk Jansen: I have a problem with finding a way to update a database structure. This might be a very simple problem, just cannot find the info. I am looking at updating the structure of my database. I put an a

Re: [GENERAL] Updating database structure

2006-03-22 Thread Janning Vygen
Am Mittwoch, 22. März 2006 20:40 schrieb Luuk Jansen: > I have a problem with finding a way to update a database structure. > This might be a very simple problem, just cannot find the info. > > I am looking at updating the structure of my database. I put an > application on my production server som

Re: [GENERAL] Updating database structure

2006-03-22 Thread Johan Vromans
Luuk Jansen <[EMAIL PROTECTED]> writes: > How can I update the structure on the production server to reflect the > database on my test machine in an easy way with preservation of the data > on the production server. There are no major changes in the fields types > etc., mainly additions/deletions

[GENERAL] Updating database structure

2006-03-22 Thread Luuk Jansen
I have a problem with finding a way to update a database structure. This might be a very simple problem, just cannot find the info. I am looking at updating the structure of my database. I put an application on my production server some time ago and further developed the application till a point