What should be here instead of "???" PostgreSQL-CodePudding

It's giving me errors because of the question marks so I was wondering what should I replace them with?I'm quite new to this so sorry if I phrased it badly.

create unique index product_meta_table_productid_uindex
      on product_meta_table using ??? ("productId");

If there is anything else you guys need I will be very happy to do so, thanks in advance

CodePudding user response：

using ... defines an index type.

It is optional and when left out, will create a B-Tree index which is a sensible choice for a unique index on a string or number column.

create unique index product_meta_table_productid_uindex
      on product_meta_table ("productId");

is the same as

create unique index product_meta_table_productid_uindex
      on product_meta_table using btree ("productId");