Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Find out a particular column throughout the database in Postgresql

    @Nitika.Verma
    Recommendations Offline Message

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 623
    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.

    postgres particular column
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: