Re: is there a way - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: is there a way
Date
Msg-id 20020502154037.GB26741@wolff.to
Whole thread Raw
In response to is there a way  ("Dorward Villaruz" <dorwardv@ntsp.nec.co.jp>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: aggregate on zero rows slow?
Next
From: david blood
Date:
Subject: Tracking down Database growth