Thread: How to set up a schema default date to '2020-01-01'?
How to set up a schema default date (now) to '2020-01-01'? Whatever timezone would be OK.
On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hejian@gmail.com> wrote:
How to set up a schema default date (now) to '2020-01-01'? Whatever timezone would be OK.
What is a "schema default" (date or otherwise)?
David J.
like I create a schema: test, I want the default date to 2020-01-01, so when I do
select test.now;
the result is 2020-01-01
On Mon, Nov 9, 2020 at 9:44 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hejian@gmail.com> wrote:How to set up a schema default date (now) to '2020-01-01'? Whatever timezone would be OK.What is a "schema default" (date or otherwise)?David J.
On Mon, Nov 9, 2020 at 10:21 PM mark armon <1994hejian@gmail.com> wrote:
like I create a schema: test, I want the default date to 2020-01-01, so when I do
select test.now;the result is 2020-01-01
That is not presently a feature that PostgreSQL implements.
While you can leverage probably a custom configuration variable it might be less subtle to simply store the desired reference in a SQL function and then call the function.
David J.
On Tue, Nov 10, 2020 at 10:51:02AM +0530, mark armon <1994hejian@gmail.com> wrote: > On Mon, Nov 9, 2020 at 9:44 PM David G. Johnston <david.g.johnston@gmail.com> > wrote: > > > On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hejian@gmail.com> wrote: > > > >> How to set up a schema default date (now) to '2020-01-01'? Whatever > >> timezone would be OK. > > > > What is a "schema default" (date or otherwise)? > > > David J. > > > like I create a schema: test, I want the default date to 2020-01-01, so > when I do > > select test.now; > > the result is 2020-01-01 I would recommend that you create a stored function/procedure that returns the "default" that you want it to return, and execute a call to that, rather than executing "select test.now". The statement "select test.now" doesn't even seem to be valid sql. Bear in mind that I have no idea what you are talking about so my advice might not be helpful. I have timestamped database backups and timestamped schema update files so that my database load script knows which schema updates to apply when loading an old database backup (i.e. anything whose timestamp is later than the timestamp of the backup), which seems like it might be related to what you are after, but I don't understand the idea of a "default" date. The "date" for my schema is always the present so as to match the corresponding software in its current state. Perhaps you can explain in more detail what you are after. cheers, raf