Groff and Weinberg SQL Complete Reference - Sample database?

Paul Ganainm

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.
Why *_OH WHY_* is it not in bog standard DML format (i.e. INSERT INTO
Table_Name VALUES(..., ..., ...)?

I'm going to have to arse about with commas, INSERT INTO &c., which runs
the risk of typos, plus the table definitions are not in DDL format, in
fact they're not there at all! Why not?
Has anyone gone to the trouble of putting this data into any sort of
standard SQL (DDL + DML) format?
TIA.
Paul...
--

plinehan x__AT__x yahoo x__DOT__x com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1

Richard Huxton

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

Nov 12 '05 #2

Robert Treat

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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #3

Robert Treat

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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #4

Paul Ganainm

xz****@users.sourceforge.net says...

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.

I'll take a look at this after Christmas + New Year.
Paul...

Robert Treat

--
plinehan y_a_h_o_o and d_o_t com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.

"XML avoids the fundamental question of what we should do,
by focusing entirely on how we should do it."

quote from http://www.metatorial.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #5