Disable the more command

* Marcos Barreto de Castro <mbdecastro@yahoo.com> [000721 12:45] wrote:

Hi,

Can someone tell me how can I disable the more
command at the end of any one page display in
PostgreSQL 7.0 ? I simply don't want to be asked to
press a key to continue displaying the result of a
query.
Thanks a lot!

export PAGER=cat

:)

-Alfred

I am a beginner in pqsql and linux.
I can't connect from visual basic to my pgsql server.
When do I do telnet "host-pgsql" what is the message that have i receive
from pgsql server if my postgres port is enabled?
I just can read " connect to "host-pgsql", then i type anything and press
enter .
I read this message "connection closed by foreign host"
what do you think about this.
Thanksfully Hector Barrera

On Fri, 21 Jul 2000, Marcos Barreto de Castro wrote:

Can someone tell me how can I disable the more
command at the end of any one page display in
PostgreSQL 7.0 ? I simply don't want to be asked to
press a key to continue displaying the result of a
query.

Hmm. I don't have the answer to your question, but I have a question
which does the reverse -- how can I _enable_ the "more" function? .. when
I do, say \do, there are a lot of operators displayed, how can i see them
per page.

TIA!

---
Froilan C. Mendoza
Tridel Technologies, Inc.
http://www.tridel.net

At 16:53 21/07/00 -0500, Ingenieria de Sistemas wrote:

I am a beginner in pqsql and linux.
I can't connect from visual basic to my pgsql server.
When do I do telnet "host-pgsql" what is the message that have i receive
from pgsql server if my postgres port is enabled?
I just can read " connect to "host-pgsql", then i type anything and press
enter .
I read this message "connection closed by foreign host"
what do you think about this.

You need to install ODBC drivers on your PC, and ODBC support in PG, then
use PG just like any other ODBC data source.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

Hi,
I have installed ODBC support in PG-

PostgreSQL ODBC driver for Windows 95 (I'm using Win-NT-Wks 4.0)
ODBC Driver Name - PostgreSQL 6.50.0000
Company Name - Insight Distribution System
File Name - PSQLODBC.DLL

Postgres running on Linux RH-6.0 (HTTP,SAMBA services not working. Telnet
and FTP working fine.).
Other side I have VB-6.0 on Windows-NT-Workstations 4.0.
I want connectivity VB (front-end) and PG(Back-end).

When I do connectivity then error come - "Provider cannot be found. It may
not be properly installed."

Why does this error come ?
Thanks in advance
Anuj

-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of Philip Warner
Sent: Saturday, July 22, 2000 9:22 AM
To: Ingenieria de Sistemas; pgsql-general@hub.org
Subject: Re: [GENERAL] how connect visual basic to pgsql?

At 16:53 21/07/00 -0500, Ingenieria de Sistemas wrote:

I am a beginner in pqsql and linux.
I can't connect from visual basic to my pgsql server.
When do I do telnet "host-pgsql" what is the message that have i receive
from pgsql server if my postgres port is enabled?
I just can read " connect to "host-pgsql", then i type anything and press
enter .
I read this message "connection closed by foreign host"
what do you think about this.

You need to install ODBC drivers on your PC, and ODBC support in PG, then
use PG just like any other ODBC data source.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

Froilan Mendoza wrote:

On Fri, 21 Jul 2000, Marcos Barreto de Castro wrote:

Can someone tell me how can I disable the more
command at the end of any one page display in
PostgreSQL 7.0 ? I simply don't want to be asked to
press a key to continue displaying the result of a
query.

Hmm. I don't have the answer to your question, but I have a question
which does the reverse -- how can I _enable_ the "more" function? .. when
I do, say \do, there are a lot of operators displayed, how can i see them
per page.

\pset pager

From psql manpage (in release 7.0.2):

pager Toggles the list of a pager to do table
output. If the environment variable PAGER is
set, the output is piped to the specified
program. Otherwise more is used.

In any case, psql only uses the pager if it
seems appropriate. That means among other
things that the output is to a terminal and
that the table would normally not fit on the
screen. Because of the modular nature of
the printing routines it is not always
possible to predict the number of lines that
will actually be printed. For that reason
psql might not appear very discriminating
about when to use the pager and when not to.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Then Peter and the other apostles answered and said,
We ought to obey God rather than men."
Acts 5:29

At 10:32 22/07/00 +0530, anuj wrote:

When I do connectivity then error come - "Provider cannot be found. It may
not be properly installed."

Looks like a Windows/VB/ODBC/OLEDB error message to me, but I could be wrong.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

-----Original Message-----
From: Philip Warner [mailto:pjw@rhyme.com.au]
Sent: Saturday, July 22, 2000 4:15 PM
To: anuj; pgsql-general@hub.org
Subject: RE: [GENERAL] how connect visual basic to pgsql?

At 10:32 22/07/00 +0530, anuj wrote:

When I do connectivity then error come - "Provider cannot be found. It may
not be properly installed."

PostgreSQL ODBC driver for Windows 95 (I'm using Win-NT-Wks 4.0)

Looks like a Windows/VB/ODBC/OLEDB error message to me, but I could be

wrong.

This deriver made for Win95.
I am using Win-Nt-Wks-4.0.
Is this possible this due to different OS's ?
Best Regard,
Anuj

This deriver made for Win95.
I am using Win-Nt-Wks-4.0.
Is this possible this due to different OS's ?
Best Regard,
Anuj

What kind of application do you use and where did you install your ODBC DSN?
If your application is a service, or if you plan to share this DSN across
multiple users, you should install it under 'System DSN' entry.

This driver work perfectly on Windows NT 4.0 Server, Windows 2000
Professional and Windows 2000 Advanced Server. I used it to connect MS SQL
Server 7.0 to PostgreSQL database through 'OLE DB provider for ODBC driver'
and succeded in it. I did not test it on Windows NT Workstation 4.0, but I
see no reason why this driver shouldn't work on it.

Alex Bolenok.

-----Original Message-----
From: Alex Bolenok [mailto:abolen@chat.ru]
Sent: Monday, July 24, 2000 12:09 PM
To: anuj
Cc: pgsql-general
Subject: Re: [GENERAL] how connect visual basic to pgsql?

This deriver made for Win95.
I am using Win-Nt-Wks-4.0.
Is this possible this due to different OS's ?
Best Regard,
Anuj

What kind of application do you use and where did you install your ODBC

DSN?

I don't know , Where I have installed but I am able to see 'OLE DB provider
for ODBC driver' entry.

If your application is a service, or if you plan to share this DSN across
multiple users, you should install it under 'System DSN' entry.

I make a 'System DSN' name pg.

This driver work perfectly on Windows NT 4.0 Server, Windows 2000
Professional and Windows 2000 Advanced Server. I used it to connect MS SQL
Server 7.0 to PostgreSQL database through 'OLE DB provider for ODBC driver'
and succeded in it. I did not test it on Windows NT Workstation 4.0, but I
see no reason why this driver shouldn't work on it.

Alex Bolenok.

My connection string is :
Provider=MSDASQL.1;Password=tempdb;Persist Security Info=True;User
ID=postgres;Data Source=pg

Postgres running on Linux RH-6.0 (HTTP,SAMBA services not working. Telnet
and FTP working fine.).
Other side I have VB-6.0 on Windows-NT-Workstations 4.0.

After reinstall the VB6.0 the error msg. has been changed.
Now new error is : "could not connect to the server, could not connect to
the remote socket."
Now how to connect VB to pgsql.
Regards,
Anuj

===== Original Message from pjw@rhyme.com.au (Philip Warner) at 7/22/00 6:45
am

At 10:32 22/07/00 +0530, anuj wrote:

When I do connectivity then error come - "Provider cannot be found. It may
not be properly installed."

Looks like a Windows/VB/ODBC/OLEDB error message to me, but I could be
wrong.

I've had that error every time I installed the Insight ODBC drivers for
postgres. I never bothered researching it further since I got pgaccess
working under windows, but it would be useful to know why many of us just
can't point-and-click to success with it.

Rob Nelson
rdnelson@co.centre.pa.us

At 08:13 24/07/00 -0400, Robert D. Nelson wrote:

===== Original Message from pjw@rhyme.com.au (Philip Warner) at 7/22/00 6:45
am

At 10:32 22/07/00 +0530, anuj wrote:

When I do connectivity then error come - "Provider cannot be found. It may
not be properly installed."

Looks like a Windows/VB/ODBC/OLEDB error message to me, but I could be
wrong.

I've had that error every time I installed the Insight ODBC drivers for
postgres. I never bothered researching it further since I got pgaccess
working under windows, but it would be useful to know why many of us just
can't point-and-click to success with it.

I just upgraded to 6.5.0 (was on 6.4), with PG 7.0.2, and still don't get
the error. I did not let it install the ODBC manager, if that is relevant.
It *seems* fine.

Without a lot more information, it would be impossible to track down (eg.
when does the error appear, can you get to the data using a different
product (eg. Excel/MSQuery), how have you set up the DSN, did you reboot 17
times after the install).

You might also be want to post a message in a VB/ODBC newsgroup, since the
message is almost certainly from VB or ODBC (or a layer above ODBC).

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

At 16:36 24/07/00 +0530, anuj wrote:

This deriver made for Win95.
I am using Win-Nt-Wks-4.0.
Is this possible this due to different OS's ?
Best Regard,
Anuj

What kind of application do you use and where did you install your ODBC

DSN?

I don't know , Where I have installed but I am able to see 'OLE DB provider
for ODBC driver' entry.

Where do you see this?

If your application is a service, or if you plan to share this DSN across
multiple users, you should install it under 'System DSN' entry.

I make a 'System DSN' name pg.

And what did you set the port, server, dbname etc to?

This driver work perfectly on Windows NT 4.0 Server, Windows 2000
Professional and Windows 2000 Advanced Server. I used it to connect MS SQL
Server 7.0 to PostgreSQL database through 'OLE DB provider for ODBC driver'
and succeded in it. I did not test it on Windows NT Workstation 4.0, but I
see no reason why this driver shouldn't work on it.

Alex Bolenok.

Works for me on NT4 SP6.

My connection string is :
Provider=MSDASQL.1;Password=tempdb;Persist Security Info=True;User
ID=postgres;Data Source=pg

So you are using an ADO data control for OLEDB, is that right?

Postgres running on Linux RH-6.0 (HTTP,SAMBA services not working. Telnet
and FTP working fine.).
Other side I have VB-6.0 on Windows-NT-Workstations 4.0.

After reinstall the VB6.0 the error msg. has been changed.
Now new error is : "could not connect to the server, could not connect to
the remote socket."

This looks like either (1) postgres is not running on the server - can you
do 'psql pg' (or whatever the db name in the DSN is). Or 2, you put the
wrong port in the DSN.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

product (eg. Excel/MSQuery), how have you set up the DSN, did you reboot 17
times after the install).

Oh, that must be it! I only rebooted 16 times! ;)

Rob Nelson
rdnelson@co.centre.pa.us

-----Original Message-----
From: Alex Bolenok [mailto:abolen@chat.ru]
Sent: Monday, July 24, 2000 6:43 PM
To: anuj
Subject: Re: [GENERAL] how connect visual basic to pgsql?

After reinstall the VB6.0 the error msg. has been changed.
Now new error is : "could not connect to the server, could not connect to
the remote socket."
Now how to connect VB to pgsql.
Regards,
Anuj

Aha. The driver is now responding. Check out if postmaster is running and
lstening on the machine you are trying to connect to and if it does, the
connection should be made.
Alex Bolenok.

Yes, Postmaster is running fine.
$ psql tempdb ----- outout-- tempdb=>
This command runing fine.
And using libpq, I am able to use Postgres.
What is remote socket error !!
Regards,
Anuj

I don't know , Where I have installed but I am able to see 'OLE DB

provider

for ODBC driver' entry.

Where do you see this?

In "ADO data control 6.0", properties .

And what did you set the port, server, dbname etc to?

Data Source:pg
database:tempdb
Server:10.1.1.50
Post:5432
username:postgres
password:**********

So you are using an ADO data control for OLEDB, is that right?

Yes. ADO data control 6.0.

This looks like either (1) postgres is not running on the server - can you
do 'psql pg' (or whatever the db name in the DSN is). Or 2, you put the
wrong port in the DSN.

1. Yes, Postmaster is running fine. '$psql tempdb' running fine. I am using
postgres through libpg.
2. How can I know what is right port ?

Best regards,
Anuj