Re: [PERFORM] Having MANY MANY empty columns in database

2008-03-22 Thread sathiya psql
> > OK, so your tables all have the same fields (columns), as if you used > CREATE TABLE new_table ( LIKE some_template_table ) ? It will contain some other unique columns for each table. > meaning that they contain NULL values in that field for every record? what is the value it may contain

Re: [PERFORM] Having MANY MANY empty columns in database

2008-03-22 Thread Craig Ringer
In a database which we are having we have nearly 100 tables, and in 75% of the tables we have 6 columns ( INT ) as standard columns. What is standard columns, if you create a table in this database you should have some default 6 columns in there they should maintain 1. who is the owner of th

[PERFORM] Having MANY MANY empty columns in database

2008-03-21 Thread sathiya psql
Hi All, I want some clarification in the following, In a database which we are having we have nearly 100 tables, and in 75% of the tables we have 6 columns ( INT ) as standard columns. What is standard columns, if you create a table in this database you should have some default 6 columns in there