Home > mailing lists

Embedded Vacuum sql - Mailing list pgsql-interfaces

From	Jaspreet Singh
Subject	Embedded Vacuum sql
Date	May 30, 2000 01:41:54
Msg-id	026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com Whole thread Raw
Responses	Re: Embedded Vacuum sql (Michael Meskes <meskes@postgresql.org>)
List	pgsql-interfaces

Hi,

I am a developing a PGE application in 6.5.3 using ecpg and libpq.

However I am unable to Vacuum Analyze the tables using embedded sql. But the same command works from the prompt through vacuumdb comand.

This I detect while query. My query takes 1 hr if vacuum hasn't been done on the database.

I use the following command :-

"EXEC SQL VACUUM ANALYZE <Table Name>

Kindly let me know how to use embedded sql to vacuum analyze.

thanx and regards,

jaspreet

From: Joseph Shraibman
Date: 30 May 2000, 01:37:37
Subject: Re: jdbc driver: Why it isn't jdbcCompliant?

From: Valik
Date: 30 May 2000, 01:42:15
Subject: What ODBC driver to use for Win98/NT 4.0/W2K?