How to get a list column names and datatypes of a table in PostgreSQL?

by 
SELECT
    column_name,
    data_type
FROM
    information_schema.columns
WHERE
    table_name="table_name";

with the above query you can columns and its datatype

More Related Contents:

  1. How do I (or can I) SELECT DISTINCT on multiple columns?
  2. How to speed up insertion performance in PostgreSQL
  3. PostgreSQL GROUP BY different from MySQL?
  4. How can I import a JSON file into PostgreSQL?
  5. Return multiple columns of the same row as JSON array of objects
  6. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  7. Normalize array subscripts so they start with 1
  8. Is there a way to define a named constant in a PostgreSQL query?
  9. Getting all Buildings in range of 5 miles from specified coordinates
  10. Call a set-returning function with an array argument multiple times
  11. Fastest check if row exists in PostgreSQL
  12. PostgreSQL ORDER BY issue – natural sort
  13. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  14. Slow simple update query on PostgreSQL database with 3 million rows
  15. Discard millisecond part from timestamp
  16. Return setof record (virtual table) from function
  17. How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?
  18. SQL column reference “id” is ambiguous
  19. How to use multiple CTEs in a single SQL query?
  20. IN Clause with NULL or IS NULL
  21. How to convert PostgreSQL 9.4’s jsonb type to float
  22. postgres – where in (list) – column does not exist
  23. incomplete information from query on pg_views [duplicate]
  24. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  25. Rails 4 LIKE query – ActiveRecord adds quotes
  26. pseudo_encrypt() function in plpgsql that takes bigint
  27. How to group timestamps into islands (based on arbitrary gap)?
  28. Run a query with a LIMIT/OFFSET and also get the total number of rows
  29. How to create a new database with the hstore extension already installed?
  30. Padding zeros to the left in postgreSQL

Leave a Comment