> -----Original Message----- > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > Sent: 01 August 2005 15:36 > To: Magnus Hagander > Cc: Dave Page; Tom Lane; PostgreSQL-development > Subject: Re: [HACKERS] Remote administration functionality > > Uh, not sure why it would be harder. What system would be easier? > Sure, file I/O works, but you can't even try to do that from psql.
In pgAdmin we would need to track all the changes the user makes to the file, and generate all the appropriate insert, update and delete queries to make the server match what the user wants. With file IO, we just let the user edit, then send the resulting file in one select statement. WRT to doing it in psql, the average psql user is probably the same person that would prefer to use vi or emacs to do the job anyway. /D ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings