On Thu, May 02, 2002 at 10:45:38AM -0700,
Dorward Villaruz <dorwardv@ntsp.nec.co.jp> wrote:
> Hello guys, i have a little problem concerning postgres
>
> 1) is there a way to time execution of sql statements in postgres without using any frontend languages like php ?
> 2) is there also a way of inserting 2000000 records to a table without using any frontend languages like php?
Presumably you want something that doesn't take a lot of typing that you
could run from psql?
You might try inserting a few values and then use a cross join of this
table(s) multiple times to generate a lot of rows.