Nam Phan
10/07/2022, 8:23 AMJan Kos
10/07/2022, 9:28 AMNam Phan
10/07/2022, 9:45 AMNam Phan
10/07/2022, 9:46 AMgooddata | 172.18.0.1 - - [07/Oct/20220945:48 +0000] “PUT /api/v1/layout/dataSources/2301ccb2-e158-4636-bb28-add45f5a0c51/physicalModel HTTP/1.1” 204 0 “http://localhost:3000/modeler/” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36”
gooddata | 172.18.0.1 - - [07/Oct/20220945:48 +0000] “GET /api/v1/layout/dataSources/2301ccb2-e158-4636-bb28-add45f5a0c51/physicalModel HTTP/1.1" 200 52 “http://localhost:3000/modeler/” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36"
Jan Soubusta
10/07/2022, 12:48 PMNam Phan
10/07/2022, 1:51 PMJan Soubusta
10/07/2022, 2:08 PMNam Phan
10/07/2022, 2:27 PMNam Phan
10/07/2022, 2:27 PMJan Soubusta
10/07/2022, 2:30 PMNam Phan
10/07/2022, 2:31 PMJan Soubusta
10/07/2022, 2:32 PMNam Phan
10/07/2022, 2:32 PMJan Soubusta
10/07/2022, 2:33 PMNam Phan
10/07/2022, 2:34 PMJan Soubusta
10/07/2022, 2:36 PM|
prefix?Nam Phan
10/07/2022, 2:36 PM|
Jan Soubusta
10/07/2022, 2:37 PMJan Soubusta
10/07/2022, 2:37 PMNam Phan
10/07/2022, 2:37 PMJan Soubusta
10/07/2022, 2:39 PMJan Soubusta
10/07/2022, 2:40 PMJan Soubusta
10/07/2022, 2:41 PMNam Phan
10/07/2022, 2:48 PMJan Soubusta
10/07/2022, 3:08 PMdocker-compose exec <gooddata service name> bash
psql -U postgres -h postgres postgres
select * from information_schema.tables where table_schema = 'public'
Nam Phan
10/07/2022, 3:17 PMpostgres=# select * from information_schema.tables where table_schema = ‘public’
postgres-# select * from postgres.tables
postgres-# select * from public.tables
postgres-# select * from postgres.public.tables
postgres-#
Nam Phan
10/07/2022, 3:17 PMJan Soubusta
10/07/2022, 3:18 PMselect * from information_schema.tables where table_schema = 'public';
Nam Phan
10/07/2022, 3:21 PMpostgres=# select * from information_schema.tables where table_schema = ‘public’;
table_catalog | table_schema | table_name | table_type | self_referencing_column_name | reference_generation | user_defined_type_catalog | user_defined_type_schema | user_de
fined_type_name | is_insertable_into | is_typed | commit_action
---------------+--------------+------------+------------+------------------------------+----------------------+---------------------------+--------------------------+--------
----------------+--------------------+----------+---------------
(0 rows)
postgres=#
Jan Soubusta
10/07/2022, 3:21 PMJan Soubusta
10/07/2022, 3:21 PMJan Soubusta
10/07/2022, 3:22 PMNam Phan
10/07/2022, 3:24 PMJan Soubusta
10/07/2022, 3:25 PM