Re: psql wishes or even realized?

>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

Steve


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