>
> select * from env_info,summary,plat_info;
>
> Is my statement broken? Is this not legal? Postgres just sits there....
>
> My goal is to select everything from multiple tables with one sql
> statement.
You didn't join the tables. This will join each row to every other row.
This will take a long time.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026