473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Groff and Weinberg SQL Complete Reference - Sample database?



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
4 3128
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
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
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

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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Ale | last post by:
Ciao a tutti. Ho eliminato il database di esempio SAMPLE(non cancellato). Ora lo voglio reinstallare ma durante l'installazione mi da il seguente errore: nella finestra con scritto SQL1005N c'è...
2
by: Zippy | last post by:
Some months ago, we requested help from this newsgroup on how to replace the library reference of a database with another library reference, prior to creating an MDE. I got the following answer...
3
by: Arjen | last post by:
Hello, I need a very simple login management system. I can create it by myself... but if somebody has done this before... it can saves me a lot of time. What I want is this: - Form...
1
by: Dave | last post by:
Hi all, My question is: How do you obtain a complete list of all the users that are registered on the local machine? I've been trying for hours now and can't find anything that will help on...
4
by: Steve Goldman | last post by:
Even asking this question probably demonstrates that I have a fundamental misunderstanding of how values and references work in C#, but here goes: I'd like to assign a reference to an arbitrary...
6
by: zhif | last post by:
I installed IBM DB2 Database for Window (Ver. 9) before. Meanwhile, I installed the database SAMPLE. Because I forgot my password, I uninstalled later on. Several days ago, I reinstalled again....
1
by: DennisBetten | last post by:
First of all, I need to give some credit to Mahesh Chand for providing me with an excellent basis to export data to excel. What does this code do: As the title says, this code is capable of...
1
debasisdas
by: debasisdas | last post by:
This is a sample code for taking backup and restore of access database Dim DBTempSource As Database Dim DBTempDestination As Database Dim RecTempSource As Recordset Dim RecTempDestination...
2
by: sarahms2201974 | last post by:
Hi, I'm attempting to create a database that holds a simple typing test and I'm having some trouble setting it up. I've created a table that holds 5 test samples. The thought is when someone...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.