Is there any limitation on the number of columns or the number of rows fetched by the select query in "create table as select ..." statement?
Junior Member
create table as select ...
Is there any limitation on the number of columns or the number of rows fetched by the select query in "create table as select ..." statement?
Senior Member
Number of columns: yes. It's written somewhere in the AdminGuide (I don't have it here).
Number of rows: your disk space? ;-) It's virtually unlimited, in reality you will run into physical limits.
Junior Member
Columns limit per table/view is 1600.
Carlo Ascani - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
carlo.ascani@2ndQuadrant.it | www.2ndQuadrant.it
Reply With Quote
