Antw: Re: psql wishes or even realized?

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