Re: [ADMIN] PostgreSQL questions

Поиск
Список
Период
Сортировка
От Peter Mount
Тема Re: [ADMIN] PostgreSQL questions
Дата
Msg-id Pine.LNX.3.95.980517163519.9809B-100000@retep.org.uk
обсуждение исходный текст
Ответ на PostgreSQL questions  (The Hermit Hacker <scrappy@hub.org>)
Список 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@retep.org.uk or petermount@earthling.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@maidstone.gov.uk


В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Mount
Дата:
Сообщение: Re: your mail
Следующее
От: Andy Lewis
Дата:
Сообщение: Re: [ADMIN] postgresql-6.3.2 question