6

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?

Vadim Kotov
  • 7,766
  • 8
  • 46
  • 61
stef
  • 25,579
  • 30
  • 103
  • 142
  • 1
    It is not for PgAdmin, but maybe this is useful: http://stackoverflow.com/questions/5350088/how-to-search-a-specific-value-in-all-tables-postgresql – DavidEG Oct 12 '11 at 08:00
  • Thanks. That's quite cumbersome ... weird there is no solution for this, it' so useful. – stef Oct 12 '11 at 08:02
  • Posted an answer, then looked at these comments. 1. No, it can easily be used from pgAdmin. 2. That's not cumbersome at all, it requires only Copy/Paste, then run. – alexkovelsky Feb 03 '15 at 15:08

2 Answers2

3

It currently doesn't exist in PgAdmin.

Kuberchaun
  • 27,671
  • 6
  • 47
  • 57
1

There's custom function for this. You can use it from Query tool. See [How to search a specific value in all tables (PostgreSQL)? ](as of today, there are two modifications in answers there that include column name, progress reporting)

Community
  • 1
  • 1
alexkovelsky
  • 3,405
  • 1
  • 24
  • 20