Re: Does pgadmin4 work with postgresql 8.4?

On Tue, Aug 6, 2019 at 7:57 AM Adrian Klaver wrote: > On 8/5/19 7:04 PM, Murtuza Zabuawala wrote: > > No, pgAdmin4 only supports PostgreSQL 9.2 and later versions. > > Where is that mentioned in the documentation? > It is mentioned on the front page of https://www.p

Re: Does pgadmin4 work with postgresql 8.4?

No, pgAdmin4 only supports PostgreSQL 9.2 and later versions. On Tue, 6 Aug 2019, 01:45 Benedict Holland, wrote: > The subject says it all. I am using a very old database that I cant > upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4? > > Thanks, > ~Ben >

Re: Case Insensitive

On Thu, Mar 28, 2019 at 1:50 PM Sridhar N Bamandlapally < sridhar@gmail.com> wrote: > Hi PG-General and Pgsql-Admin > > Can we achieve CASE INSENSITIVE in PostgreSQL? > You can try *select * from emp where ename *ILIKE *'aaa';* > > I mean, need below way > > postgres=# select * from emp; >

Re: Forks of pgadmin3?

On Fri, Mar 22, 2019 at 9:55 PM wrote: > This is probably my 10th attempt to move from pgadminIII to pgadmin4. At > least the performance has significantly improved over time and seems now > acceptable. > > The biggest drawback is however that all elements are locked up in one > browser window –

Re: the installation of pgadmin4 makes me weep in frustration

package lists wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - 3) sudo apt-get update 4) sudo apt-get install pgadmin4 Check https://www.postgresql.org/download/linux/ubuntu/ for more information. -- Regards, Murtuza Zabuawala EnterpriseDB: http

Re: What is wrong with my pgadmin?

Hello, This is a bug with pgAdmin4 (Bug: RM#3090 <https://redmine.postgresql.org/issues/3090>). Work around for this problem is to set lc_messages = 'en_US.UTF-8' in "postgresql.conf" file. -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com

Re: pgadmin4: not possible to create server

Add following in your pg_hba.conf, hostall all 0.0.0.0/ 0 md5 restart your Postgres database server and try to connect again from pgAdmin4. On Tue, Feb 6, 2018 at 10:54 PM, robert rottermann wrote: > Hi there, > > I have installed pgadmin4 local

Re: [GENERAL] Date Time data types

As per my knowledge, CLOCK_TIMESTAMP value changes every time you call it even in the same transaction BEGIN ... CLOCK_TIMESTAMP() -- Gives 2017-11-23 15:02:27.492867+05:30 ... ... CLOCK_TIMESTAMP() -- Gives different time as per current clock time ... END; CURRENT_TIMESTAMP ​is t

Re: unsubscribe

On Tue, Nov 21, 2017 at 12:49 PM, Craig Ringer wrote: > On 21 November 2017 at 15:17, Rafal Pietrak wrote: > >> Hi all, >> >> Have anyone noticed, that last couple of days on the list, can become a >> nice example of HOWTO turn the best list on the planet into a nightmare? >> >> Pls forgive rude