How to find a table having a specific column in postgresql

by

You can also do

 select table_name from information_schema.columns where column_name="your_column_name"

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. How to implement a many-to-many relationship in PostgreSQL?
  3. Optimise PostgreSQL for fast testing
  4. Transpose latest rows per user to columns
  5. How to delete duplicate rows without unique identifier
  6. Best way to check for “empty or null value”
  7. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  8. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  9. PostgreSQL parameterized Order By / Limit in table function
  10. Compute percents from SUM() in the same SELECT sql query
  11. SQL Between clause with strings columns
  12. Postgres analogue to CROSS APPLY in SQL Server
  13. Insert an image in postgresql database
  14. NOT NULL constraint over a set of columns
  15. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  16. How do I alter the position of a column in a PostgreSQL database table?
  17. Query that ignore the spaces
  18. Continuing a transaction after primary key violation error
  19. INSERT COMMAND :: ERROR: column “value” does not exist
  20. Use email address as primary key?
  21. Bulk/batch update/upsert in PostgreSQL
  22. SQL query to find record with ID not in another table
  23. How to show row numbers in PostgreSQL query?
  24. Grant privileges for a particular database in PostgreSQL
  25. Upsert with a transaction
  26. How to use SQL LIKE condition with multiple values in PostgreSQL?
  27. How to create a new database with the hstore extension already installed?
  28. PostgreSQL how to create a copy of a database or schema?
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment