On Mon, 22 Aug 2005, Paul Bramble wrote: > Is there an easy way to get started so I can quickly install Postgress and > load my schema?
You didn't say what kind of system you're running, but getting a packaged version of PostgreSQL (RPM, DEB, Windows Installer) will probably help on the install side. Once it's installed, you'll need to make an actual database and load the schema file. That might be as simple as doing something like the following as the postgres user: createdb dbname psql dbname -f foo.sql ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match