Re: Groff and Weinberg SQL Complete Reference - Sample database?

On Monday 22 December 2003 07:47, Paul Ganainm wrote:
> Not really a PostgreSQL question, but maybe somebody here knows the
> answer!
>
>
> I recently purchased Groff and Weinberg's The Complete Reference SQL,
> and a fine meaty tome it is too!
>
>
> However, I find to my absolute *_horror_* that there doesn't appear to
> be an electronic version of the sample database - it's all down on paper
> in Appendix A, but no way of downloading it electronically.
>
> On the CD, there are files such as office.dat where the data is in the
> format
>
> 22|Denver|Western|108|300000.00|186042.00
> 11|New York|Eastern|106|575000.00|692637.00
>
> i.e. pipe delimited.

Read up on \copy and COPY - you can tell PG to use whatever delimiter you
want. Should make it straightforward then.

--
  Richard Huxton
  Archonet Ltd