NYCPHP Meetup

NYPHP.org

[nycphp-talk] 'CHECK TABLE' syntax for Postgres

max max at neuropunks.org
Thu Aug 18 11:35:32 EDT 2005


May be you are looking for this:
http://www.postgresql.org/docs/7.4/interactive/sql-vacuum.html
?
Works for both 7.x and 8.x

On Thu, Aug 18, 2005 at 11:21:31AM -0400, Jayesh Sheth wrote:
> Hello all,
> 
> I am back from the land of the disappeared. How has the weather in
> NYPHPland been since I was gone?
> 
> I have a question that I hope some Postgres gurus could answer. MySQL
> lets you run a query with the syntax 'CHECK TABLE my_table' to see what
> is wrong with it. More info:
> http://dev.mysql.com/doc/mysql/en/check-table.html
> 
> I was wondering if Postgres has something similar, or if it uses an
> external tool. I did a fair bit of Googling, but have come up with
> nothing so far.
> 
> Also - does it have something similar to MySQL's 'REPAIR TABLE' syntax
> if problems are found and tables need to be repaired? More info:
> http://dev.mysql.com/doc/mysql/en/repair-table.html
> 
> Thanks in advance.
> 
> Best regards,
> 
> - Jay
> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org
> 



More information about the talk mailing list