postgresqlintellij-idea
Intellij postgres can't see tables even though connected
I'm trying to use the database tool in intellij (pycharm) instead of the usual postgres cli psql.
However although the IDE can connect to postgres and see the different databases I can't seem to see any tables within in for some reason. There doesn't seem to be a helpful guide to set this up unfortunately.
Intellij:
psql:
Solution
The connection to the database needs to be specific to that database not just the general postgres database.
eg in View-> Tool windows-> Database
Then click on database setting icon and for the url have (on osx at least):
jdbc:postgresql://localhost:5432/yourdatabase
- Why 5.0 / 2 returns 2.5000000000000000 (scale of 16) instead of 2.5 (scale of 1)?
- TypeError: not all arguments converted during string formatting - psycopg2
- How to prevent PostgreSQL from altering my nicely formatted SQL definitions
- How can I update a large table slowly?
- How do you find the row count for all your tables in Postgres
- How to select all users who are registered in all the same events as current user
- Postgres import dump ignoring duplicates
- Multi-Tenant Spring boot web application
- How to perform read queries on read replica in postgres?
- How can I query what security labels exist on a table?
- PostgreSQL, bulk update using data from another table
- Django 5.1 + Postgresql (debian server)
- How to use values from CTE in ON CONFLICT UPDATE
- Can't build Docker image with Postgresql
- checking java date with postgresql timestamp without timezone
- Enable debugging of postgresql functions on database inside a docker container using pgAdmin
- TypeORM: Custom Many To Many Relationship
- Delete json object from jsonb type column based on key of json object in postgresql
- Docker runs PostgreSQL in "trust" mode
- How to fix Postgres error "operator does not exist" using pgvector
- Rails 4 scope NOTNULL refactor
- postgreSQL index not found why?
- Select on self-referencing table where all chains meet a condition
- How to successfully save data to another database column in postgresql using jetpack compose?
- In a join, fields with null values are not getting shown but in normal query they are
- Install pgAgent on AWS RDS for Postgres
- Spring JBDC bad SQL grammar on PostgreSQL
- Using IF in function for different queries as a result
- Is it possible to have a CSV header when exporting table to file/stdout directly in SQL query and not in post-processing step?
- Variables in looping condition in a postgreSQL while loop