Re: is there a way

Dixit "Dorward Villaruz" <dorwardv(at)ntsp(dot)nec(dot)co(dot)jp> (le Thu, 2 May 2002 10:45:38 -0700) :

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?

You always need a frontend language to speak with a server ;-)

It may be a general purpose web server side language or it may be
other languages like PERL, Python, C... You also have the "psql" unix
shell command that gives you interactive session with the postgresql
database. Just write your SQL statements in a file and say :

psql -f your-filename your-database

and your statements will be executed. You can time a unix command with
"time cmd" so "time psql -f your-filename your-database".

Best regards.

Thierry Besancon