Re: export pgadmin user list

From: Jan Birk <jan(dot)g(dot)birk(at)gmail(dot)com>
To: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>, Jianping Wei <jwei(at)truecar(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: export pgadmin user list
Date: 2019-07-24 06:04:07
Message-ID: 09a416286061692865b2161eb4d4fb0deff99f00.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

You can export a user list on several ways:

1) from the CLI use sqlite
--------------------------
$ sqlite3 pgadmin4.db
select * from user ;

2) create a postgres_fdw and have access from pgadmin4 it self
---------------------------------------------------------------
https://wiki.postgresql.org/wiki/Foreign_data_wrappers

3) from the gui (browser)
-------------------------
Install (at least in FF) an extention ex SQLite Manager

All 3 bullets will demand access to the database pgadmin4.db file.

Best

/Jan

ons, 24 07 2019 kl. 09:34 +0530, skrev Khushboo Vashi:
> Hi Jianping,
>
> On Tue, Jul 23, 2019 at 11:26 PM Jianping Wei <jwei(at)truecar(dot)com> wrote:
> > Hello,
> >
> > I am running PGadmin 4.x. Is there a way I can export pgadmin user list?
> >
> >
>
> It's not supported right now, you can log this request at
> https://redmine.postgresql.org/projects/pgadmin4
>
> Thanks,
> Khushboo
>
> > Thanks,
> >

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2019-07-24 08:47:27 Re: can't export server list
Previous Message Khushboo Vashi 2019-07-24 04:04:01 Re: export pgadmin user list