| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Dorward Villaruz <dorwardv(at)ntsp(dot)nec(dot)co(dot)jp> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: is there a way |
| Date: | 2002-05-02 15:40:37 |
| Message-ID: | 20020502154037.GB26741@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 02, 2002 at 10:45:38AM -0700,
Dorward Villaruz <dorwardv(at)ntsp(dot)nec(dot)co(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | david blood | 2002-05-02 15:41:41 | Tracking down Database growth |
| Previous Message | Bruno Wolff III | 2002-05-02 15:34:19 | Re: HOWTO - Random character generation for primary key |