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