Thread: dbsamples from pgfoundry

dbsamples from pgfoundry

From
"Tommy Gibbons"
Date:
Hi,
I would like some pointers as to how to install the dbsamples so that I can use them in Postgres.  These .tar.qz files seem to contain *.sql files.  These seem to be text files but I do not understand how to import to postgres or if there is some command line command to run.

These samples are on http://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/

Tommy.

Re: dbsamples from pgfoundry

From
"A. Kretschmer"
Date:
am  Mon, dem 29.09.2008, um 22:52:52 +0100 mailte Tommy Gibbons folgendes:
> Hi,
> I would like some pointers as to how to install the dbsamples so that I can use
> them in Postgres.  These .tar.qz files seem to contain *.sql files.  These seem
> to be text files but I do not understand how to import to postgres or if there
> is some command line command to run.

Use psql for that, either within psql with \i or call psql with option
-f file.sql


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net