> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> 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