Skip site navigation (1) Skip section navigation (2)

Re: sql file in the tutorial directory

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Pavel SRB <srb(at)heckler-koch(dot)cz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: sql file in the tutorial directory
Date: 2007-11-22 03:04:04
Message-ID: 1195700644.13217.14.camel@linda.lfix.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 2007-11-21 at 17:56 +0100, Pavel SRB wrote:
> hi all, before few days i have installed via apt-get version 8.1 to my 
> debian etch machine.
> 
> after reading lesson 3 in tutorial [ 
> http://www.postgresql.org/docs/8.1/static/tutorial-advanced.html ]
> i was looking for these sql files. But i do not find any on my system 
> also not on web. Can you please tell from where can i get them. Thank 
> you very much
> 
> Pavel SBR
> 
> these are packeges available on my system
> 
> rc  postgresql                        7.5.22                           
> object-relational SQL database management sy
> ii  postgresql-8.1                    8.1.9-0etch2                     
> object-relational SQL database, version 8.1
> rc  postgresql-client                 7.5.22                           
> front-end programs for PostgreSQL (transitio
> ii  postgresql-client-8.1             8.1.9-0etch2                     
> front-end programs for PostgreSQL 8.1
> ii  postgresql-client-common          71                               
> manager for multiple PostgreSQL client versi
> ii  postgresql-common                 71                               
> manager for PostgreSQL database clusters
> ii  postgresql-doc-8.1                8.1.9-0etch2                     
> documentation for the PostgreSQL database ma

You also need to install postgresql-server-dev-8.1 in order to build the
functions referred to by the tutorial.

The tutorial files are in /usr/share/doc/postgresql-doc-8.1/tutorial.
However, this is not a writable directory, so you need to copy it to
your home directory and work on your own versions:

cp -a tutorial ~
cd ~/tutorial
make

The make creates the file you are looking for.

-- 
Oliver Elphick                                          olly(at)lfix(dot)co(dot)uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
 You're nearly out of time!   http://www.lfix.co.uk/disappearance.html


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


In response to

pgsql-novice by date

Next:From: Jason Tan Boon TeckDate: 2007-11-22 03:44:05
Subject: SQL statements equivalent to pg_dump
Previous:From: Robert M. BernabeDate: 2007-11-21 23:26:13
Subject: Execute RAISE problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group