Re: Groff and Weinberg SQL Complete Reference - Sample

Paul,

once you get through the book perhaps you could submit a book review to
the techdocs website, along with a pg_dump of the sample database.

Robert Treat

On Mon, 2003-12-22 at 05:50, Richard Huxton wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL