| From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
|---|---|
| To: | "Dorward Villaruz" <dorwardv(at)ntsp(dot)nec(dot)co(dot)jp>, "Postgres General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: is there a way |
| Date: | 2002-05-02 14:20:43 |
| Message-ID: | 200205021020.43496.lamar.owen@wgcr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 02 May 2002 01:45 pm, Dorward Villaruz wrote:
> 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?
Well, if shell doesn't count as a language, use:
time psql -c $query $database
where $query is the query you want to time (quoted properly, of course) and
$database is the database the query is accessing.
The COPY command does the second part -- see the documentation on details of
data format, file location, syntax and soforth.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fran Fabrizio | 2002-05-02 14:30:50 | Re: Joe Celko Function : problem |
| Previous Message | Tom Lane | 2002-05-02 14:15:29 | Re: Using views and MS access via odbc |