Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Search in all tables in PgAdmin

Tags:

postgresql

pgadmin

In PgAdmin, is it possible to search for a value in ALL tables? In phpmyadmin this is possible and quite convenient. You search for an ID value and find all the tables in which it occurs. I can't seem to find this function in PgAdmin.

Does it exist?

like image 834
stef Avatar asked Oct 12 '11 07:10

stef

People also ask

How do I search pgAdmin?

Use the Find menu to search, replace, or navigate the code displayed in the SQL Editor: Select Find to provide a search target, and search the SQL Editor contents. Select Find next to locate the next occurrence of the search target. Select Find previous to move to the last occurrence of the search target.

1 Answers

It currently doesn't exist in PgAdmin.

like image 92
Kuberchaun Avatar answered Nov 02 '22 19:11

Kuberchaun
Sign in to Comment

Related questions

flyway unable to connect to postgres container within docker-entrypoint-initdb.d script
how to handle null in date field of postgresql
Can't connect to postgres db from pgadmin (both running on docker)?
How to import a large csv file(~4GB) to PostreSQL database?
How to obtain constant memory usage when migrating a Rails application from mongoid (MongoDB) to ActiveRecord (Postgres)?
PostgreSQL C function: libpq doesn't link?
Lateral Join in django queryset (in order to use jsonb_to_recordset postgresql function)
How to exclude multiple values of column using Django ORM?
Don't round float input silently when inserting into integer column
Is it possible to create a table with a variable name in PostgreSQL?
Postgresql: split database between different machines
Date query with Hibernate on Timestamp Column in PostgreSQL
Conditionally set a column to its default value in Postgres
Why is count(*) taking extremely long in one PostgreSQL database but not another?
Find rows that have a field which is a substring of the search string
Which DBMSs offer index-organized tables?
Postgresql pivot? Crosstab?
Is there a lightweight sql parser class written in PHP to do this? [closed]
PostgreSQL - How to see Function Text/Source in pgAdmin?
Error using SqlSoup with database views

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!