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
  • 8,084
  • 8
  • 48
  • 62
stef
  • 26,771
  • 31
  • 105
  • 143
  • 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
  • 29,160
  • 7
  • 51
  • 59
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,880
  • 1
  • 27
  • 21