I'm sorry, but I have not found such construction into documentation: SELECT tablename FROM tablename;
http://www.postgresql.org/docs/8.4/static/queries-overview.html say: [WITH with_queries] SELECT select_list FROM table_expression [sort_specification] http://www.postgresql.org/docs/8.4/static/queries-select-lists.html say: "The select list determines which columns of the intermediate table are actually output." But, table name is not a column. Reproduce: tmp=# create table tmp(id SERIAL, name VARCHAR(10)); NOTICE: CREATE TABLE will create implicit sequence "tmp_id_seq" for serial column "tmp.id" CREATE TABLE tmp=# insert into tmp (name) values('John'); INSERT 0 1 tmp=# insert into tmp (name) values('Pol'); INSERT 0 1 tmp=# insert into tmp (name) values('Martin'); INSERT 0 1 tmp=# select tmp from tmp; tmp ------------ (1,John) (2,Pol) (3,Martin) (3 rows) What is this? Is this undocumented or am I bad looked in the documentation? With best wishes, Victor Vislobokov St.Peterburg. Russia
