Postgres Pro
Downloads
Home   >   mailing lists

Thread: Date Dimension

Date Dimension

From
Chuma Ofole
Date:
Hi Everybody,

I am using Pgadmin 4.Can someone tell me how to create and populate data in date dimension?

Thanks in advance!

Chuma

unsubscribe

From
"U. Brauchli (update)"
Date:

Re: Date Dimension

From
Melvin Davidson
Date:
Is this what you want?

Click Tools
    Query Tool

CREATE TABLE has_date_col
( some_date_info DATE);

INSERT INTO has_date_col
(some_date_info)
VALUES
('2017-06-01'),
('2017-06-08');

SELECT * FROM has_date_col;

Also RTFM

and



Melvin Davidson 🎸
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com




On Wednesday, June 21, 2017, 6:15:45 PM EDT, Chuma Ofole <cofole@aol.de> wrote:


Hi Everybody,

I am using Pgadmin 4.Can someone tell me how to create and populate data in date dimension?

Thanks in advance!

Chuma