Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Find out a particular column throughout the database in Postgresql

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 620
    Comment on it

    Previously got a situation where I needed to get the list of all the tables where a particular column lets say partner_id exists, might be useful for you too.

    Just run the following query in PostgreSQL:

    SELECT * FROM information_schema.columns WHERE column_name = 'partner_id'
    

    You will see the list of all the tables where partner_id column exists.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: