Re: Unable to installed postgis extension using stack builder

2021-01-31 Thread Aditya Toshniwal
Hi Cadstructure, Can you please tell from where did you download the installer ? On Sat, Jan 30, 2021 at 5:30 PM Cadstructure Technology < cadstructur...@gmail.com> wrote: > Good day, > I have installed my desktop postgres apps. but when I am trying to > install postgis extension using stack

Re: Unable to installed postgis extension using stack builder

2021-01-31 Thread Fahar Abbas
Hi, I have already added an appropriate email list, Kindly always use pgsql-b...@lists.postgresql.org instead of pgadmin-supp...@postgresql.org for all postgreSQL related issues. On Sat, Jan 30, 2021 at 5:00 PM Cadstructure Technology < cadstructur...@gmail.com> wrote: > Good day, > I have

Re: Better use of screen width for query tabs

2021-01-31 Thread Khushboo Vashi
Hi, On Fri, Jan 29, 2021 at 10:26 PM Trung Do wrote: > Hi, > > Currently, the left browser tree panel is not collapsible, and the > Properties/SQL/Statistics/Dependencies/Dependents tabs are not even > closable, so together they take up nearly half my screen width. > Because of this, I can only

Re: authentication fail

2021-01-31 Thread Khushboo Vashi
Hi, Looks like you are running pgAdmin 4 version 4.1 and the latest version is 4.30. Please upgrade the pgAdmin to the latest and your issue will be resolved. Thanks, Khushboo On Sat, Jan 30, 2021 at 1:58 PM Michael Eschweiler < michael.eschwei...@web.de> wrote: > Hi Khushboo, > > Am 12.01.21

Re: Default custom format for specific columns?

2021-01-31 Thread Aditya Toshniwal
Hi Dave, On Sun, Jan 31, 2021 at 9:16 PM Dave Caughey wrote: > In my databases, timestamps are stored as longs (epoch millis). > > Consequently, when I do a query or view table, I always end up with values > like 1612106244000, rather than a more readable format of "2021-01-31 > 15:17:24". > >

Default custom format for specific columns?

2021-01-31 Thread Dave Caughey
In my databases, timestamps are stored as longs (epoch millis). Consequently, when I do a query or view table, I always end up with values like 1612106244000, rather than a more readable format of "2021-01-31 15:17:24". Yes, I realize I can do "to_timestamp(cast(mytimestamp/1000 as