From: Keith Gray <keith@heart.com.au>
To: Roberto Mello <rmello@cc.usu.edu>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: ipsql (was - Escape Quotes)
Date: Fri, 11 May 2001 15:22:07 +1000
Message-ID: <3AFB76FF.78A8203C@heart.com.au> (raw)
References: <3AFB3C52.315C48F0@heart.com.au>
<11049.989548443@sss.pgh.pa.us>
<3AFB512B.50E9951B@heart.com.au>
<3AFB59D5.E7B9DAAB@heart.com.au>
<20010510224542.A16437@cc.usu.edu>
Roberto Mello wrote:
>
> What the heck is ipsql??
>
> -Roberto
ipgsql
A Win32 client for interactive Postgres session
Keith
Attachments:Readme (text/plain, 2.1K) download
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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: keith@heart.com.au, rmello@cc.usu.edu, tgl@sss.pgh.pa.us
Subject: Re: ipsql (was - Escape Quotes)
In-Reply-To: <3AFB76FF.78A8203C@heart.com.au>
References: <3AFB3C52.315C48F0@heart.com.au> <11049.989548443@sss.pgh.pa.us> <3AFB512B.50E9951B@heart.com.au> <3AFB59D5.E7B9DAAB@heart.com.au> <20010510224542.A16437@cc.usu.edu> <3AFB76FF.78A8203C@heart.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox