Re: [Gnumed-devel] examining current schemas

[Horst Herb]

On Mon, 12 Jul 2004 17:15, Horst Herb wrote:
> > Well, is it not important to know for backup purposes? Not only to keep
> > backup volumes manageable, but in the event of a computer problem may
> > it not be important to be able to restore selectively (e.g. only data),
> > and not all of the system and application software.

Once again, just to make it clear: Postgresql does not store information in 
individual files, at least not in the conventional sense. It uses so-to-say 
it's own file system on top of the OS file system. That includes all stored 
procedures, trigger functions, indices etc.

If you want to retrieve, add or modify information within a Postgres database, 
there is no other way than going through the server - and that includes 
backup/restire. Would be bad if it would be otherwise. Interbase and Mysql 
are poorly designed in that aspect.

Horst