Finding tables in pgAdmin
How to find tables using pgAdmin.
Click datasource as one example - this is where the raw data from a datasource is downloaded and stored.
Click Tables to see the list of tables in this schema
Click rxnorm_rxnconso and then click Columns to see all the columns in this table
RIGHT click rxnorm_rxnconso → click View/Edit Data → click First 100 Rows to see some example data in the right-side of the window
Go back to your list of schemas, but this time, click on staging.
While there may be a few views in the staging schema, generally we will use tables.
Click on Tables.
You can see that the staging tables are objects like “dose forms” and “ingredients”.
You can inspect columns and view top 100 rows just like you did with the datasource tables.
You can repeat the above steps for the intermediate schema, which will also mostly consist of tables