sql - How do I retrieve all tuples from similar tables in a postgresql database? -


i've postgresql database nice property. tables within database have same schema. created using model query.

create table tablex (s varchar(100), p varchar(100), o varchar(100)) 

now i'm interested on retrieving data these tables in 1 shot. can names using following query :

select table_name information_schema.tables table_schema='public' 

but struggle return contain of tables ( name in result of above query). i've try following query

select tab.s, tab.p, tab.o   (select table_name        information_schema.tables        table_schema='public') tab 

but it's not working. , following error message pgadm3

error:  column tab.s not exist line 1: select tab.s, tab.p, tab.o            ^ ********** erreur **********  error: column tab.s not exist État sql :42703 caractère : 151 

any idea how deal ?


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -