Re: [Gnumed-devel] examining current schemas

[Karsten Hilbert]

> I now gather that the .sql files (in the SQL directory) are just the 
> SQL commands which serve to define the databases and tables together 
> with providing some additional descriptive text.
Exactly. It is intended to be fairly self-documenting.

> Are the actual databases and tables created, and test data loaded, by 
> the bootstrap procedure? As part of the bootstrap, does it "call" or 
> "run" these SQL files?
Exactly.

> Where do the databases and tables with their data actually reside? I 
> note a directory gnumed/gnumed/data but I cannot see that it contains much.
cd <homedir of PG demon user> (often postgres or pgsql)
cd data

eg. cd /var/lib/pgsql/data/ on my Suse 7.3 laptop.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346