Thread: Tool for filling database
Hi ! Me again. Has anybody of users found any tools that could be used for filling database with lot of data....I mean with nice interface so that you can easily fill different tables....something like Access maybe....but not do bg. i don't want to install whole office 2000 so I could use oDBC link to access dB. So anybody has anything for me... So for graphical representation, I need to make around 400 entries in database. Some of entries are similar...and in some entries part of it is similar to others. Yeah a lot of typing.... Andy ************************************************************************** * Aleksander Rozman - Andy * Fandoms: E2:EA, SAABer, Trekkie, Earthie * * andy@kksonline.com * Sentinel, BH 90210, True's Trooper, * * andy@atechnet.dhs.org * Heller's Angel, Questie, Legacy, PO5, * * Maribor, Slovenia (Europe) * Profiler, Buffy (Slayerete), Pretender * * ICQ-UIC: 4911125 ********************************************* * PGP key available * http://www.atechnet.dhs.org/~andy/ * **************************************************************************
Aleksander Rozman - Andy wrote: >Has anybody of users found any tools that could be used for >filling database with lot of data....I mean with nice interface so that you >can easily fill different tables....something like Access maybe....but not >do bg. . . . >Yeah a lot of typing.... Well, if you have to do lots of typing anyway, why you don't you stick it into a text file, say delimited using '|' marks, and then just use the "copy" command in postgreSQL to populate the table. Then create indices on the table, and you are good to go. That's what I do. (In fact, I write little shell scripts to speed up the process, and redo the work in case I ever feel like dropping and recreating the table. After you write one shell script, modifying it to handle other tables is easy.) Moreover the pg manual says it's very fast to use "copy" to populate your table. -serge
Aleksander Rozman - Andy <andy@kksonline.com> writes: > Hi ! > > Me again. Has anybody of users found any tools that could be used for > filling database with lot of data....I mean with nice interface so that you > can easily fill different tables....something like Access maybe....but not > do bg. i don't want to install whole office 2000 so I could use oDBC link > to access dB. So anybody has anything for me... So for graphical > representation, I need to make around 400 entries in database. Some of > entries are similar...and in some entries part of it is similar to others. > Yeah a lot of typing.... <snip> Have you looked into 'pgaccess'? -- Prasanth Kumar kumar1@home.com