Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: command

Re: command

From
"Henshall, Stuart - Design & Print"
Date:

Florian Litot wrote:
> what is the command to launch a sql script not in psql thanks
>
>
psql is used to execute sql scripts as follows:
psql -f <filename> <database>
hth,
- Stuart

Re: command

From
Florian Litot
Date:
Hi
i would like to know if postgresql have driver for the ado or bde?
thanks

Re: command

From
"Dave Page"
Date:

> -----Original Message-----
> From: Florian Litot [mailto:flitot@besancon.sema.slb.com]
> Sent: 05 November 2002 15:39
> To: pgsql-cygwin@postgresql.org
> Subject: Re: [CYGWIN] command
>
>
> Hi
> i would like to know if postgresql have driver for the ado or
> bde? thanks

You can use the ODBC driver with ADO. http://odbc.postgresql.org/

Regards, Dave.

Re: command

From
"joek hondius"
Date:
Hi!

There is no BDE driver to my knowledge,
but there are DBX (DBExpress) drivers for Borland Delphi/Kylix and cbuilder.
Also there is a postgresql driver for availiable from Vita Voom Software
www.vitavoom.com
On PostgreSQL < 7.2.1  teh GPL www.ZeosLib.org works,
later versions work with either a custom .BKI script or patched Zeos driver.

Be warned:
We tested performance of the respective drivers,
and ODBC is VERY VERY VERY bandwidth comsuming.
In our C/S app ODBC is impossible to use on a 10 mbps ethernet.
Furthermore you need to install the ODBC driver on each client,
whereas DBX is kinda build-in the executable.

An impression of network traffic in our app per session:
ODBC:                aprox 3 MB
Oracle8 /w OCI/ADO:    620 kB
ms SQL server7:        450 kB
DBX                400 kB
Zeos                380 kB

Note that ODBC also needs a really significant amount of
CPU-time after the data have (finally) arrived.
In our app some 2,5 seconds extra on pIII 600,
on top of 3,5 secs for data.

My guess is that PostgreSQL or its ODBC driver is not to blame for this,
but Micro$oft's specs...

Greetings, JH



-----Oorspronkelijk bericht-----
Van: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]Namens Dave Page
Verzonden: dinsdag 5 november 2002 16:51
Aan: Florian Litot; pgsql-cygwin@postgresql.org
Onderwerp: Re: [CYGWIN] command




> -----Original Message-----
> From: Florian Litot [mailto:flitot@besancon.sema.slb.com]
> Sent: 05 November 2002 15:39
> To: pgsql-cygwin@postgresql.org
> Subject: Re: [CYGWIN] command
>
>
> Hi
> i would like to know if postgresql have driver for the ado or
> bde? thanks

You can use the ODBC driver with ADO. http://odbc.postgresql.org/

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: command

From
"Dave Page"
Date:

> -----Original Message-----
> From: joek hondius [mailto:jhondius@rem.nl]
> Sent: 06 November 2002 10:27
> To: pgsql-cygwin@postgresql.org
> Subject: Re: [CYGWIN] command
>
> Be warned:
> We tested performance of the respective drivers,
> and ODBC is VERY VERY VERY bandwidth comsuming.
> In our C/S app ODBC is impossible to use on a 10 mbps
> ethernet.

I don't know what your app is doing, but I can manage servers at work
using pgAdmin II (which uses ODBC) from home over a 33.6Kb modem
connection quite happily.

Regards, Dave.

Invalid EUC_JP character sequence found.

From
"Lakshmi Narayanan V"
Date:
Hi
    I have just installed cygwin with postgresql 7.2.3.

    When I try to use \copy with japanese text in the data file
I get "Invlalid EUC_JP character sequence found" error.

    I used pgAdmin to create my database with EUC_JP encoding.

    Please help me in fixing this problem.  Thanks.

Lakshmi Narayanan V

trace

From
Florian Litot
Date:
How i can trace in a file?
  i try
$ postmaster -i -D /cygdrive/c/cygwin/usr/local/pgsql/data -d 2 >logfile

but the trace doesn't exist
why?

Re: trace

From
Jason Tishler
Date:
Florian,

On Thu, Nov 07, 2002 at 11:15:50AM +0100, Florian Litot wrote:
> How i can trace in a file?
>  i try
> $ postmaster -i -D /cygdrive/c/cygwin/usr/local/pgsql/data -d 2 >logfile
>
> but the trace doesn't exist
> why?

Are you looking for strace?  If so, then it exists under Cygwin.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: trace

From
Florian Litot
Date:
i try to found a trace of postgresql which request is launch and why i have
got some problem

At 14:02 07/11/02, Jason Tishler wrote:
>Florian,
>
>On Thu, Nov 07, 2002 at 11:15:50AM +0100, Florian Litot wrote:
> > How i can trace in a file?
> >  i try
> > $ postmaster -i -D /cygdrive/c/cygwin/usr/local/pgsql/data -d 2 >logfile
> >
> > but the trace doesn't exist
> > why?
>
>Are you looking for strace?  If so, then it exists under Cygwin.
>
>Jason
>
>--
>PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
>Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6