Thread: Re: [ADMIN] PostgreSQL questions

>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.

>>I belive the tcl/tk shell is a full shell with the PG libraries compiled in.
>>would someone please correct me if I am wrong.
>
>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?
>>
>>Is the postmaster running with ip enabled ???? postmaster -i -B 256......
>>you can check using netstat -an|grep 5432
>>The -i turns IP on, otherwise postgresql is only using Unix Sockets.
>
>3. The \copy command. What do I use for the delimeter of each field?
>   I can't seem to find that in the documentation.
>>try:
>>template1=> \h copy
        Command: copy
        Description: copy data to and from a table
        Syntax:
        copy [binary] <class_name> [with oids]
                {to|from} {<filename>|stdin|stdout} [using delimiters <delim>];
>>you can use "\t" a  HTab  or "," a comma. that is what i generally use.
>>Check the mailing list archive there was a thread about speeding up copy
>>operations
>>by using a fifo.(could we add this to the documentation or is it??)


                Hope  I helped,

                        --Robert Reilly
                            rjreilly@scni.com

> >>try:
> >>template1=> \h copy
>         Command: copy
>         Description: copy data to and from a table
>         Syntax:
>         copy [binary] <class_name> [with oids]
>                 {to|from} {<filename>|stdin|stdout} [using delimiters <delim>];
> >>you can use "\t" a  HTab  or "," a comma. that is what i generally use.
> >>Check the mailing list archive there was a thread about speeding up copy
> >>operations
> >>by using a fifo.(could we add this to the documentation or is it??)

Actually copy and \copy are not the same, and \copy does not currently
take a delimiter, though it is on the TODO list now.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)