Hi!
Can anyone tell me how can I insert an information from a text file to a
PostgreSQL database when the text file is continously being updated with a
new information.
Alternatively if I have a freebsd program which continously echoes to the
console screen some information, how can I insert that information to the
database and to correct columns, using some regular expressions method.
The information is like the following...
[PHP]
U:1.2.28, 9502935, 1(inactive),(absolute) bytes rx 0, tx 108, (absolute)
pkts rx 0, tx 1,
F:1.2.29, 9508081, 136.141.179.137, 137.141.179.159, 137, 137, 17(udp), 0,
0, 1, 17, None, 0, 134.141.179.156,
5-minute, low, none, 2, 295,
U:1.2.29, 9512536, 1(inactive), (absolute) bytes rx 0, tx 108, (absolute)
pkts rx 0, tx 1,
F:1.2.30, 9517114, 136.141.179.137, 137.141.179.159, 137, 137, 17(udp), 0,
0, 1, 17, None, 0, 134.141.179.156,
5-minute, low, none, 2, 295,
U:1.2.30, 9520537, 1(inactive), (absolute) bytes rx 0, tx 108, (absolute)
pkts rx 0, tx 1,
F:1.2.31, 9527415, 50.141.179.153, 136.141.179.137, 1345, 37, 17(udp), 0, 0,
17, 1, None, 0, 134.141.179.156,
5-minute, low, none, 111, 2,
F:1.2.32, 9527415, 136.141.179.137, 50.141.179.153, 37, 1345, 17(udp), 0, 0,
1, 0, None, 0, 134.141.179.156,
5-minute, low, none, 2, 3909,
U:1.2.32, 9531740, 1(inactive), (absolute) bytes rx 0, tx 64, (absolute)
pkts rx 0, tx 1,
U:1.2.31, 9531740, 1(inactive), (absolute) bytes rx 0, tx 46, (absolute)
pkts rx 0, tx 1,
F:1.2.33, 9535506, 50.141.179.150, 136.141.179.137, 1024, 37, 17(udp), 0, 0,
17, 1, None, 0, 134.141.179.156,
5-minute, low, none, 111, 2,
F:1.2.34, 9535506, 136.141.179.137, 50.141.179.150, 37, 1024, 17(udp), 0, 0,
1, 0, None, 0, 134.141.179.156,
5-minute, low, none, 2, 3595,
[/PHP]
Thanks in Advance!
--
View this message in context:
http://www.nabble.com/Reading-from-a-text-file%2C-or-unix-console-screen-tf3485879.html#a9731631
Sent from the PostgreSQL - general mailing list archive at Nabble.com.