Re: [GENERAL] how to use pg-connect ?

2000-01-26 Thread Sarah Officer 

I would like more info about the pgtcl commands, too.  In the
"Integrated Document" on the postgres web page, there's a list of
commands (chapter 49), but not detailed information.  When I enter
pgtclsh, I can get a list of options.  For pg_connect, I get this:

% pg_connect
pg_connect: database name missing
pg_connect databaseName [-host hostName] [-port portNumber] [-tty
pgtty]]
pg_connect -conninfo conninfo-string

This is fairly intuitive, but the pg_result command isn't as
obvious:
% pg_result
Wrong # of arguments
pg_result result ?option? where option is
-status
-error
-conn
-oid
-numTuples
-numAttrs
-assign arrayVarName
-assignbyidx arrayVarName ?appendstr?
-getTuple tupleNumber
-tupleArray tupleNumber arrayVarName
-attributes
-lAttributes
-clear

Is there a description of these options in one of the other
documents?

Sarah Officer
[EMAIL PROTECTED]

Cécile DESNOYERS wrote:
 
 Hello,
 
 I'd like to know if there is a way to use pg_connect() with a
 different host than « localhost ».
 I tried to put an IP address or a server name but it didn't work. Has
 anybody ever used pg_connect with something else than localhost ?
 
 Thank you
 
 Cecile

Re: [GENERAL] how to use pg-connect ?

2000-01-26 Thread Robert Wagner 

Dear Cecile,

You can do this with a connection string:

pg_connect -conninfo $string

...or directly, dos/unix style, as in

pg_connect $database -host $host -port $portNumber

Cheers
Rob





C


écile DESNOYERS [EMAIL PROTECTED] on 01/26/2000 12:48:14 PM

To:   [EMAIL PROTECTED]
cc:(bcc: Robert Wagner/SIAC)
Subject:  [GENERAL] how to use pg-connect ?





Hello,


 I'd like to know if there is a way to use pg_connect() with a
different host than 


« localhost ».
 I tried to put an IP address or a server name but it didn't work. Has
anybody ever used pg_connect with something else than localhost ?


 Thank you

  Cecile

RE: [GENERAL] how to use pg-connect ?

2000-01-26 Thread Fabian . Frederick 


 Dear Cecile,
 
 You can do this with a connection string:
 
 pg_connect -conninfo $string
 
 ...or directly, dos/unix style, as in
 
 pg_connect $database -host $host -port $portNumber
PS : port number can be found in /tmp/socket file