How to set up a schema default date to '2020-01-01'?

[mark armon]

How to set up a schema default date (now) to '2020-01-01'?  Whatever
timezone would be OK.

Re: How to set up a schema default date to '2020-01-01'?

[mark armon]

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 
wrote:

> On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hej...@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.
>

pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

[mark armon]

OS: Windows
issue:
https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors

pg_dump: error: server version: 13.0; pg_dump version: 12.4
pg_dump: error: aborting because of server version mismatch

-
-
-
-

Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

[mark armon]

where to get pg_dump 13.0?

On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver 
wrote:

> On 11/28/20 8:12 AM, mark armon wrote:
> >
> > OS: Windows
> > issue:
> >
> https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors
> > <
> https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors
> >
> >
> > |pg_dump: error: server version: 13.0; pg_dump version: 12.4 pg_dump:
> > error: aborting because of server version mismatch |
> >
>
> You are trying to dump a Postgres 13.0 version instance using the 12.4
> version of pg_dump. That will not work as the error says. You need to
> find and use the 13.0 version of pg_dump  and use that. FYI, it will
> work the other way e.g. a newer version of pg_dump can dump an older
> version of Postgres.
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>