Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

list column names of multiple tables psql

SELECT column_name , table_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers' or TABLE_NAME = N'Customers1' or TABLE_NAME = N'Customers'
 
PREVIOUS NEXT
Tagged: #list #column #names #multiple #tables #psql
ADD COMMENT
Topic
Name
8+8 =