Re: [GENERAL] filling database

2013-08-26 Thread Steve Crawford
On 08/23/2013 03:29 AM, sachin kotwal wrote: create sample table with one or two rows then use following command to populate data. INSERT INTO TABLE_NAME VALUES(generate_series(1,10)); Cartesian joins are also useful - especially when you want semi-realistic data. A quick Google will g

Re: [GENERAL] filling database

2013-08-23 Thread sachin kotwal
/GENERAL-filling-database-tp1843856p5768376.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] filling database

2005-05-20 Thread Dan Black
EMS PostgreSQL Data Generator http://sqlmanager.net/products/postgresql/datagenerator And you can write you own pgplsql function that fill you database with any random data. I think it would be better and cheaper =) 2005/5/20, [EMAIL PROTECTED] <[EMAIL PROTECTED] >:hi,Does anyone know of a tool

[GENERAL] filling database

2005-05-20 Thread [EMAIL PROTECTED]
hi, Does anyone know of a tool for filling the database with alot of random data... so that I can add millions of rows to test approx how well it will scale ? tia - http://linuxtoday.com/news_story.php3?ltsn=2004-12-08-004-32-OS-BZ-DT-0005 snip> MS Office is popular in the same way as heart