Roberto Mello wrote:
>
> What the heck is ipsql??
>
> -Roberto
ipgsql
A Win32 client for interactive Postgres session
Keith README
Interactive PostgreSQL presents comfortable windows environment
to execute sql queries, edit tables data, view tables list and
structure, execute sql scripts, etc.
This application design on Delphi using PostgreSQL components,
which included in Winzeos Library:
http://www.zeos.dn.ua/download/winzeos-latest.zip
PARAMETERS
Connect parameters for Interactive PostgreSQL stored in the
ipgsql.ini file in the same directory that ipgsql.exe
You can change its manually or using File/Options dialog
Parameters short description:
[Preferences]
PgSQLPort=<N> ; PostgreSQL port number (default 5432)
IsAlive=1 ; Open alive queries (default 1)
IsCached=0 ; Use cached updates (default 0)
QueryAll=0 ; Query all records when open (default 0)
AutoCommit=0 ; Auto commit updates (default 0)
AutoRecovery=0 ; Auto rollback transaction when
; errors occured (default 1)
Login=<login> ; PostgreSQL login (no default)
Host=<host name> ; Host name (no default)
DataBase=<db name> ; Database name (no default)
EXTRA FEATURES
Program supports PostgreSQL Large Objects. In postgreSQL
database they represented as Oid fields which store LO handle.
In IPgSql these fields translate to Blob field.
You may store in Blob fields text, images or any binary data.
Open blob field editor by double click in grid or choose
View/Blob Editor menu item.
LICENCING
Zeos Library is distributed with the GPL licence and
costs you nothing.
DOWNLOADS
The latest version can be found on:
http://www.zeos.dn.ua/download/ipgsql-latest.zip
KNOWN BUGS
1. When your sql query crash and AutoRecovery set to false
end transaction manually.
If AutoRecovery set to true after crash transaction
is auto rollbacked.
2. IPgSql works only with PostgreSQL 6.5+
CREDITS
- Steve Wei for idea and support designing PostgreSQL components
Yours,
Sergey Seroukhov, Chief Engineering of Capella Development Group.
<voland@kita.dgtu.donetsk.ua>