1. I have created the first table and inserted records as below<br />CREATE TABLE mytest (<br /> staid
varchar(20),<br/> kdesc varchar(50) -- description of gage station <br /> )<br /> WITHOUT OIDS;<br
/><br/><br /> INSERT INTO mytest VALUES ('96784002', 'mylocation #1');<br />INSERT INTO mytest VALUES ('02385067',
'mylocation#2');<br />INSERT INTO mytest VALUES ('01734056', 'mylocation #3');<br />INSERT INTO mytest VALUES
('04784097','mylocation #4');<br />INSERT INTO mytest VALUES ('16784201', 'mylocation #5');<br /><br /> 2. The records
looklike this.<br /><br /> SELECT * FROM mytest;<br /><br /> ++++++++++++++++++++++++++<br />"96784002";"mylocation
#1"<br/>"02385067";"mylocation #2"<br />"01734056";"mylocation #3"<br />"04784097";"mylocation #4"<br
/>"16784201";"mylocation#5"<br />++++++++++++++++++++++++++<br /><br /> 3. What I want to do is to create tables with
staidfrom mytest table using for loop.<br />But, since the name of tables should be in text format, I added a string
's'to staid. <br />Thus, the name of table should be like this s96784002 because of 's' +'staid'.<br /><br
/>+++Example+++<br/><br /> CREATE TABLE s06784000 (<br /> staid varchar(50),<br /> val
real, -- streamflow<br /> date date<br />)<br /><br /> WITHOUT OIDS;<br /><br /><br /><br /> 4. I
mustcreate tables using for loop because I have millions of records. <br /><br />I appreciate your help in advance. <br
/><br/><br />Jae<br /><br /><br /><br /><br /><hr />강력해진 보안성, 아웃룩을 닮아 편리해진 기능들로 무장한 Windows Live Hotmail! <a
href="http://www.hotmail.com"target="_new">뜨거운 메일 핫메일, Windows Live Hotmail로 돌아오다!</a>
