newbie123 avatar image
newbie123 asked

Partition for PostgreSQL

I have a SQL query: ANALYSE TABLE CUST_STAT COMPUTE STATISTICS; it works well in Oracle, but recently I am switching to use PostgreSQL, I change the SQL to: ANALYSE CUST_STAT COMPUTE STATISTICS; I already read the manual section on partitioning, I know the TABLE keywords is not needed in PostgreSQL, but I still getting error for the PARTITION : ANALYZE CUST_STAT PARTITION CUST_STAT_P201307 ; Can anyone help?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
You might be lucky and get a response here but this forum is focussed primarily on SQL Server. It could be worth posting your question on too.
1 Like 1 ·

0 Answers