Skip site navigation (1) Skip section navigation (2)

Re: convert text file to database

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: convert text file to database
Date: 2008-04-22 08:36:59
Message-ID: 298a6f60804220136q13d9215ekd81af689aa5b2247@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
i think you want convert text file to database. You can use COPY
command and you can add a column whose value is id number such as
1,2,3....you can set the column is series type or you can first create
a sequence and set default value of new column be sequence .

SQL is :

1. ALTER TABLE xxxxx

 ADD COLUMN id series;

2.

CREATE SEQUENCE  public. mile_danxianhe_gid_seq

    INCREMENT 1  MINVALUE 1

    MAXVALUE 9223372036854775807  START 1

CACHE 1;

ALTER TABLE public.yantian_2006_mile

ADD COLUMN id integer DEFAULT nextval('mile_danxianhe_gid_seq'::regclass);

wish you can understand my explain.

best regard.


                       windwxc



----- Original Message -----
From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [NOVICE] convert text file to database
Date: 08-04-21 22:52:40

I amended a copy of my csv files as follows

2,OnlineGame,wwwflyordiecom,yyyy/mm/dd,1,player1,player2,0-1,normal,yyyy/mm/dd,1200,1d4d5...33Bf3Rxe50-1
3,OnlineGame,wwwflyordiecom,yyyy/mm/dd,1,player1,player2,0-1,normal,yyyy/mm/dd,1,player1,player2,1200,1e4d52e5d4...Nxf2#0-1

Compared to my original csv file, I had to remove the field names that
were in the csv file (e.g. event,onlinegame,site,www...,date,yyyy....

I also had to remove all full stop (.) characters, such as in the url
name and within the list of moves (e.g. 1. e4 d7 2. gf3...). Instead
of removing the full stops, could I have prefixed the character with
the backstroke (\), e.g. to become www\.flyordie\.com? The user guide
says so but when I tried the csv file import failed.

Moreover, I had to add an id number to represent the id primary key,
as the first column of data. I thought there would be a way to
automatically add this column to the csv file?

-- 
Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice


 -------------------------------------------------------------------
 想玩得精彩?快来惠普"我的电脑 我的舞台"(
http://d1.sina.com.cn/sina/limeng3/mail_zhuiyu/2008/mail_zhuiyu_20080421.html
)

 -------------------------------------------------------------------
 注册新浪2G免费邮箱(http://mail.sina.com.cn/)

pgsql-novice by date

Next:From: Andrej Ricnik-BayDate: 2008-04-22 09:36:50
Subject: Re: Remote / network connection fails
Previous:From: e-letterDate: 2008-04-21 14:52:40
Subject: Re: convert text file to database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group