Hi, I have two tables.
create table blue (
id serial primary key,
name text not null,
kill text not null
);
create table red (
id serial primary key,
name text not null,
kiss text not null
);
select blue.name from blue union select red.name from red; give me this:
name
'blabla'
'bubu'
'haha'
'kkk'
I want this:
name table_name
'blabla' blue
'bubu' blue
'haha' red
'kkk' red
Could I?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
