{"id":5426,"date":"2016-10-21T06:11:22","date_gmt":"2016-10-21T06:11:22","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=5426"},"modified":"2017-04-20T11:13:42","modified_gmt":"2017-04-20T11:13:42","slug":"how-to-get-column-names-from-postgresql-table","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/postgresql\/how-to-get-column-names-from-postgresql-table.html","title":{"rendered":"How to get column names from PostgreSQL table"},"content":{"rendered":"<p><code>select column_name from information_schema.columns where table_name='my_table_name'<\/code><\/p>\n<p>see also:<\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/sql%20server\/how-to-get-column-names-from-sql-server-table.html\">How to get column names from Sql Server table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/db2\/how-to-get-column-names-from-db2-table.html\">How to get column names from DB2 table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/oracle\/how-to-get-column-names-from-oracle-table.html\">How to get column names from Oracle table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/mysql\/how-to-get-column-names-from-mysql-table.html\">How to get column names from Mysql table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/sqlite\/how-to-get-column-names-from-sqlite-table.html\">How to get column names from SQLite table<\/a><\/p>\n<p>Some PostgreSQL tools you can try: <a href=\"https:\/\/www.withdata.com\/postgresql\/\"> https:\/\/www.withdata.com\/postgresql\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>select column_name from information_schema.columns where table_name=&#8217;my_table_name&#8217; see also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Oracle table How to get column names from Mysql table How to get column names from SQLite table Some PostgreSQL tools you can try: [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[430],"tags":[],"class_list":["post-5426","post","type-post","status-publish","format-standard","hentry","category-postgresql"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/5426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=5426"}],"version-history":[{"count":3,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/5426\/revisions"}],"predecessor-version":[{"id":6471,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/5426\/revisions\/6471"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=5426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=5426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=5426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}