From: | Peter Mount <pgsqladmin(at)retep(dot)org(dot)uk> |
---|---|
To: | Ben Hoang <bhoang(at)nortel(dot)ca> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] PostgreSQL questions |
Date: | 1998-05-17 15:39:12 |
Message-ID: | Pine.LNX.3.95.980517163519.9809B-100000@retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sat, 16 May 1998, The Hermit Hacker wrote:
> I just installed the postgresql database into our Sun enterprise 5000 machine.
> I have a few questions to ask if you don't mind.
>
> 1. Is there a TCL extension to this database? I see you have a pgtksh, pktclsh
> interpreter compiled with the package. I was thinking if I can have the
> postgresql interfaces incorporated to our TCL/TK interpreter.
It's been a while since I played with building TCL/TK interpretters, but
IIRC, simply add the pgtcl init code into your own interpretter, and
compile.
> 2. I can't seem to figure out how I can setup to run the psql clients on
> other sun machines beside the server that the postmaster is running on.
> Do you know how I can setup to do that?
$(PGDATA)/pg_hba.conf defines how/who can connect remotely. Also, the
postmaster must have the -i flag, which enables TCP/IP networking.
> 3. The \copy command. What do I use for the delimeter of each field?
> I can't seem to find that in the documentation.
It defaults to tab, but you can define your own. Try:
\h copy
--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Lewis | 1998-05-17 18:40:20 | Re: [ADMIN] postgresql-6.3.2 question |
Previous Message | Peter Mount | 1998-05-17 15:34:11 | Re: your mail |