How to get all the user list from postgresql database

[Srikanth A]

BackStory : 

• I have setup BigBlueButton(V2.2) and greenlight 
• Some students got registered in that site using greenlight front end 
• As a admin, I am able to see that in manage users section 
• Green Light is storing the user data in the postgresql by default 

Question : 
I want to know, How to access that DB and how to export the Data from that DB 

[Dominik Meyer]

in you greenlight-folder to get users:

docker exec greenlight-v2 psql "postgresql://postgres:<hereyourpw>@db:5432/<hereyourdbname>" -c "select * from users;" 

Liebe Grüße

Dominik

--
You received this message because you are subscribed to the Google Groups "BigBlueButton-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bigbluebutton-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bigbluebutton-dev/cc1df711-59a3-4fc6-8a99-8cd53b4a589ao%40googlegroups.com.

[Srikanth A]

Thanks for the quick reply Dominik Meyer,

I tried with the command you provided 
I am getting "users " does not exist

"

ERROR:  relation "users" does not exist

LINE 1: select * from users;

"


On Monday, June 8, 2020 at 8:48:09 PM UTC+5:30, Dominik Meyer wrote:

in you greenlight-folder to get users:

docker exec greenlight-v2 psql "postgresql://postgres:<hereyourpw>@db:5432/<hereyourdbname>" -c "select * from users;" 

Liebe Grüße

Dominik

Am Mo., 8. Juni 2020 um 17:13 Uhr schrieb Srikanth A <srikan...@gmail.com>:

BackStory : 

• I have setup BigBlueButton(V2.2) and greenlight 
• Some students got registered in that site using greenlight front end 
• As a admin, I am able to see that in manage users section 
• Green Light is storing the user data in the postgresql by default 

Question : 
I want to know, How to access that DB and how to export the Data from that DB 

--
You received this message because you are subscribed to the Google Groups "BigBlueButton-dev" group.

To unsubscribe from this group and stop receiving emails from it, send an email to bigblueb...@googlegroups.com.

[Dominik Meyer]

docker exec greenlight-v2 psql "postgresql://postgres:<hereyourpw>@db:5432/<hereyourdbname>" -c "SELECT * FROM pg_catalog.pg_tables WHERE schemaname != 'pg_catalog' AND schemaname != 'information_schema';"

there you get the tables from. is there not a user table?

 

Liebe Grüße

Dominik

To unsubscribe from this group and stop receiving emails from it, send an email to bigbluebutton-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bigbluebutton-dev/eb5408d4-dae1-4cd5-aeab-8c5b087f097eo%40googlegroups.com.

[Srikanth A]

I didnot get any table here 

query result 

 schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers | rowsecurity

------------+-----------+------------+------------+------------+----------+-------------+-------------

(0 rows)

On Monday, June 8, 2020 at 9:10:02 PM UTC+5:30, Dominik Meyer wrote:

docker exec greenlight-v2 psql "postgresql://postgres:<hereyourpw>@db:5432/<hereyourdbname>" -c "SELECT * FROM pg_catalog.pg_tables WHERE schemaname != 'pg_catalog' AND schemaname != 'information_schema';"

there you get the tables from. is there not a user table?

 

Liebe Grüße

Dominik

To view this discussion on the web visit https://groups.google.com/d/msgid/bigbluebutton-dev/eb5408d4-dae1-4cd5-aeab-8c5b087f097eo%40googlegroups.com.

[Srikanth A]

in my docker-compose.yml file 
I have POSTGRES_DB = postgres

So Used "postgres" in <hereyourdbname> command, in that DB there is nothing 

After looking other possible ways, found there is another DB which is "greenlight_production""

In that DB, I found the data

Thanks for the Help Dominik Meyer.