Thread: extract data and store
Hi: I´m novice in postgress and i need to take some information from a external plain text file and store in postgress. There are any aplication to do that ? what is the best form to do it? Thanks. Jlopez.
Hi Jesus ! You can use COPY command in psql to import txt and csv files. If you want just parts from your text you will have to search / parse the file first. For the parsing, I am afraid, you will have to write a bit of code in your preferred language. If you are using some common tools / APIs like php or cfml, there are plenty of custom functions and little scriplets readily available. Could you be a little more specific on 'some information' and 'external text file' please ? BR, aarni On Thursday 25 July 2002 02:29 am, you wrote: > Hi: > > I´m novice in postgress and i need to take some information from a > external plain text file and store in postgress. > > There are any aplication to do that ? what is the best form to do it? > > Thanks. > > Jlopez. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Hi ! How about COPY mytable FROM '/tmp/plain.txt' USING DELIMITERS ','; Taken that your file is in rows, one row for one record, no need for parsing or linefeeds / linebreaks: Like 253,0,2000-02-24,053638447fffffffffffffff,....................... 254,0,2000-02-25,053638448fffffffffffffff,....................... Of course you will have to first create the table according to your data: int, boolean?, date, varchar, ............... BR, aarni On Thursday 25 July 2002 07:16 pm, you wrote: > Hi: > > Thanks for your answer. My question is the following: > > I have a large plain text external file with registers separated by commas > like this: > > 253,0,2000-02-24,053638447fffffffffffffff,....................... > > I need to parse this and put in postgres. What is the best form of parsing > and how can I do for put this information in database. > > Thanks again for your help. > > Jlopez. > > Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote: > > Hi Jesus ! > > > > You can use COPY command in psql to import txt and csv files. > > > > If you want just parts from your text you will have to search / parse the > > file first. > > > > For the parsing, I am afraid, you will have to write a bit of code in > > your preferred language. If you are using some common tools / APIs like > > php or cfml, there are plenty of custom functions and little scriplets > > readily available. > > > > Could you be a little more specific on 'some information' and 'external > > text file' please ? > > > > BR, > > > > aarni > > > > On Thursday 25 July 2002 02:29 am, you wrote: > > > Hi: > > > > > > I´m novice in postgress and i need to take some information from a > > > external plain text file and store in postgress. > > > > > > There are any aplication to do that ? what is the best form to do it? > > > > > > Thanks. > > > > > > Jlopez. > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- TIP 4: Don't 'kill -9' the > > > postmaster
Hi Jesus ! You can use COPY command in psql to import txt and csv files. If you want just parts from your text you will have to search / parse the file first. For the parsing, I am afraid, you will have to write a bit of code in your preferred language. If you are using some common tools / APIs like php or cfml, there are plenty of custom functions and little scriplets readily available. Could you be a little more specific on 'some information' and 'external text file' please ? BR, aarni On Thursday 25 July 2002 02:29 am, you wrote: > Hi: > > I´m novice in postgress and i need to take some information from a > external plain text file and store in postgress. > > There are any aplication to do that ? what is the best form to do it? > > Thanks. > > Jlopez. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Hi ! I have only one more question before test the solution. If i have another file type with the following structure : 30 INC ANSW . . . . . . . . . CENTROB . . . . . . . . 7 1024 INC FAIL OWN . . . . . . . . . CENTROB . . . . . . . . 0 etc....... I need to extract some info from file to postgress, I supose is necesary to parse file. What if the best form to do it ? Whit perl and pipe files ? or there are a diferent form ? Thanks. Jlopez. Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote: > Hi ! > > How about COPY mytable FROM '/tmp/plain.txt' USING DELIMITERS ','; > > Taken that your file is in rows, one row for one record, no need for parsing > or linefeeds / linebreaks: > > Like > > 253,0,2000-02-24,053638447fffffffffffffff,....................... > 254,0,2000-02-25,053638448fffffffffffffff,....................... > > Of course you will have to first create the table according to your data: > > int, boolean?, date, varchar, ............... > > BR, > > aarni > > On Thursday 25 July 2002 07:16 pm, you wrote: > > Hi: > > > > Thanks for your answer. My question is the following: > > > > I have a large plain text external file with registers separated by commas > > like this: > > > > 253,0,2000-02-24,053638447fffffffffffffff,....................... > > > > I need to parse this and put in postgres. What is the best form of parsing > > and how can I do for put this information in database. > > > > Thanks again for your help. > > > > Jlopez. > > > > Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote: > > > Hi Jesus ! > > > > > > You can use COPY command in psql to import txt and csv files. > > > > > > If you want just parts from your text you will have to search / parse the > > > file first. > > > > > > For the parsing, I am afraid, you will have to write a bit of code in > > > your preferred language. If you are using some common tools / APIs like > > > php or cfml, there are plenty of custom functions and little scriplets > > > readily available. > > > > > > Could you be a little more specific on 'some information' and 'external > > > text file' please ? > > > > > > BR, > > > > > > aarni > > > > > > On Thursday 25 July 2002 02:29 am, you wrote: > > > > Hi: > > > > > > > > I´m novice in postgress and i need to take some information from a > > > > external plain text file and store in postgress. > > > > > > > > There are any aplication to do that ? what is the best form to do it? > > > > > > > > Thanks. > > > > > > > > Jlopez. > > > > > > > > > > > > > > > > ---------------------------(end of > > > > broadcast)--------------------------- TIP 4: Don't 'kill -9' the > > > > postmaster
Hi: Thanks for your answer. My question is the following: I have a large plain text external file with registers separated by commas like this: 253,0,2000-02-24,053638447fffffffffffffff,....................... I need to parse this and put in postgres. What is the best form of parsing and how can I do for put this information in database. Thanks again for your help. Jlopez. Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote: > Hi Jesus ! > > You can use COPY command in psql to import txt and csv files. > > If you want just parts from your text you will have to search / parse the > file first. > > For the parsing, I am afraid, you will have to write a bit of code in your > preferred language. If you are using some common tools / APIs like php or > cfml, there are plenty of custom functions and little scriplets readily > available. > > Could you be a little more specific on 'some information' and 'external text > file' please ? > > BR, > > aarni > > On Thursday 25 July 2002 02:29 am, you wrote: > > Hi: > > > > I´m novice in postgress and i need to take some information from a > > external plain text file and store in postgress. > > > > There are any aplication to do that ? what is the best form to do it? > > > > Thanks. > > > > Jlopez. > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster