Re: Import textfile as table
От | Shridhar Daithankar |
---|---|
Тема | Re: Import textfile as table |
Дата | |
Msg-id | 3D9C6387.31157.93B7C1F@localhost обсуждение исходный текст |
Ответ на | Import textfile as table (Michelle Konzack <linux.mailinglists@freenet.de>) |
Ответы |
Re: Import textfile as table
Re: Import textfile as table Re: Import textfile as table |
Список | pgsql-general |
On 2 Oct 2002 at 18:01, Michelle Konzack wrote: > Hello, > > I have gotten a 16 MByte textfile with around 27.000 lines of data > which contains a database with 22 fields which are <TAB> seperated. > > How can I import it into a (new) table and or new > database of pgsql. You can use \copy in psql. I don't know how would you specify tab as delimeter. May be you should convert it to some other delimeter like ':' or ',' if tab does not work. Get a small chunk of that file. First 100 records or so and experiment. Otherwise it might get quite irritating..;-) Bye Shridhar -- White's Statement: Don't lose heart!Owen's Commentary on White's Statement: ...they might want to cut it out...Byrd's Addition to Owen's Commentary: ...and they want to avoid a lengthy search.
В списке pgsql-general по дате отправления: