get table name in Postgres query result

Question

I am trying to get table name in query result. The query I am trying to do involves multiple table. This is why I am trying to get a column with result which will indicate from which table the data taken from. Here is the code I am using

(SELECT DISTINCT column_1 as keywords from table_1) 
UNION ALL
(SELECT DISTINCT column_2 as keywords from table_2)

mvp · Accepted Answer · 2013-06-10 03:39:31Z

7

Use this:

SELECT DISTINCT column_1 AS keywords, 'table_1' AS tablename
FROM table_1
UNION ALL
SELECT DISTINCT column_2 AS keywords, 'table_2' AS tablename
FROM table_2

It adds one more column tablename to result set, which contains originating table name.

answered Jun 10, 2013 at 3:39

mvp

118k15 gold badges132 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

get table name in Postgres query result

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related