Re: Antw: Re: psql wishes or even realized?

The following three paragraphs come from the PostgreSQL 7.2.1 INSTALL file:

1)

* The GNU Readline library (for comfortable line editing and command
history retrieval) will automatically be used if found. You might wish
to install it before proceeding, but it is not essential. (On NetBSD,
the "libedit" library is readline-compatible and is used if
"libreadline" is not found.)

2)

--with-includes=DIRECTORIES

"DIRECTORIES" is a colon-separated list of directories that will
be added to the list the compiler searches for header files. If
you have optional packages (such as GNU Readline) installed in a
non-standard location, you have to use this option and probably
also the corresponding "--with-libraries" option.

Example: --with-includes=/opt/gnu/include:/usr/sup/include.

3)

If you perform a build and then discover that your configure options were
wrong, or if you change anything that configure investigates (for example,
you install GNU Readline), then it's a good idea to do "gmake distclean"
before reconfiguring and rebuilding. Without this, your changes in
configuration choices may not propagate everywhere they need to.

RTFM :-)

Steve

>From: Daniel Seichter<psqlgeneral(at)dseichter(dot)de>
>To: sgbirch(at)hotmail(dot)com
>CC: PostgreSQL-General<pgsql-general(at)postgresql(dot)org>
>Subject: Antw: Re: [GENERAL] psql wishes or even realized?
>Date: Sat, 20 Jul 2002 23:51:00 +0200
>
>Hello,
>the first thing I will try tomorrow is to dump my database. I hope it works
>fine and I can extract the SQL listing. Thank you
>Do you know, if it is possible to reconfigure and compile it and install it
>with all configurations I've made, to get the readline-libary into
>postgreSQL? I had compiled it without any directives.
>
>Thanks a lot
>Daniel
>
> >>> Stephen Birch<sgbirch(at)hotmail(dot)com> 20.07.2002 22:38 >>>
> >1) sql-logfile of psql
> >after I have created some tables , I can't remember exactly the sql-code,
> >if I have done everything correctly and so, I am searching the
>possibility
> >to get a file, where all SQL-code is beeing listed, I've written with
>psql
> >(to make a TQuery with Delphi to create the same database by clicking on
>a
> >simple button)
>
>If you use pg_dump to dump the database, you will get an SQL listing of
>the database.
>
>$pg_dump database >file.dmp
>
>If you want, you can edit the dmp file and then recreate your database with
>the changes.
>
>1. pg_dump database >file.dmp
>2. vi file.dmp (make changes)
>3. dropdb database
>4. psql database -f file.dmp
>
>
> >2) better implementation of cursor-keys
> >if I have done an error in a line, I can't go to this line and fix it,
> >because I get letters like ^[[D. How is this bug to fix? I'm using the
> >german keytable.
> >
>
>When you build PostgreSQL it will pick up the GNU readline library if it is
>found. Make sure it is installed on your machine before you build. On SuSE
>7.3, I helped this by specifying the following option to configure:
>
>configure --with-include=/usr/include/guile-readline

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx