Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date - Mailing list pgsql-sql

Good morning,

Could someone tell me the command to get the weekly day name and day 
number please.


I am expecting something like:

sql> select data_part('day name', current_date);
sql> Monday

sql> select data_part('day number', current_date);
sql> 1

(Mon =1 ... Sun =7?)

Thanks a lot!


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Identifying which column matches a full text search
Next
From: "Milen A. Radev"
Date:
Subject: Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date