What is COLLATE pg_catalog. Does "Default" do with a text attribute in a postgres database table?

Question

One of the fields when creating the table is described below.

id text COLLATE pg_catalog."default" 

Answer 1

It just says that you are using lc_collate for this column by default.

But what is the default match? Use SHOW to discover this.

 SHOW lc_collate; 

PostgreSQL allows you to create columns with different types of sorting:

 CREATE TABLE collate_test ( default_collate text, --Default collation custom_collate text COLLATE pg_catalog."C" --Custom collation ); 

Have you seen the difference?

More info on matching on docs :

The sort function allows you to specify the sort order and classification of characters (...)