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