Re: Import textfile as table

Hello,

if you seed it sometimes... thanks to 'rovero'

>Run psql......
>create table table_name.........
>copy table_name from '/full/path/to/file' using delimiters '\t';

Michelle


Am 15:34 2002-10-03 +0530 hat Shridhar Daithankar geschrieben:
>
>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.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
> ##########  Get the Power of Debian/GNU-Linux  ##########