There is a typo in your spelling of "analyze". The correct syntax is:
devdb=> \h vacuum
Command: vacuum
Description: vacuum the database, i.e. cleans out deleted records, updates
statistics
Syntax:
VACUUM [VERBOSE] [ANALYZE] [table]
or
VACUUM [VERBOSE] ANALYZE [table [(attr1, ...attrN)]];
Phil Culberson
DAT Services
-----Original Message-----
From: Arnaud FLORENT [mailto:aflorent@iris-tech.fr]
Sent: Tuesday, February 01, 2000 7:34 AM
To: PostgreSQL general ML
Subject: [GENERAL] VACUUM ANALYSE
hello,
this command (VACUUM ANALYSE) doesn't work with my 6.5.2 postgres......
error message:
NOTICE: Vacuum: table not found
any suggestion?
--
______________________________
Arnaud FLORENT
IRIS Technologies
phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90
mailto:aflorent@iris-tech.fr
______________________________
************
