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 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
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
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 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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'è...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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
| |