Re: [ADMIN] PostgreSQL questions
От | Bruce Momjian |
---|---|
Тема | Re: [ADMIN] PostgreSQL questions |
Дата | |
Msg-id | 199805180142.VAA24693@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [ADMIN] PostgreSQL questions (rjreilly@scni.com) |
Список | pgsql-admin |
> >>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)
В списке pgsql-admin по дате отправления: