Re: Strange problem with create table as select * from table;

hubert depesz lubaczewski <depesz@depesz.com> writes:
> other tests are running, but simple question - how to get number of rows
> affected from psql?

> create table xxx as select * from xobjects;
> returns just:
> SELECT

We fixed that in 9.0, but 8.4 won't provide the count (unless you care to
patch it).  That's why I suggested doing a separate insert/select.

            regards, tom lane