Patrick Coulombe writes:
> I want to find the number of rows for each table (2) in 1 query,
> the query is:
To find the number of rows in one table you do
SELECT COUNT(*) FROM table;
To find the number of rows in two tables you send two queries like
that. There's no good way to do it in one sh
Craig May writes:
> I have two servers running pgsql. Is there a command to transfer the
> databases
> between them?
pg_dump and psql. "Back up" one database and "restore" it on the other
server. Don't even think about moving files around. :)
--
Peter Eisentraut Sernanders vä
Hi All!
I just wanna now how much is the capacity of the copy command...
I did a psql mydb < data.sql
inside data.sql I had a COPY "table" FROM stdin;
and around 200,000 registers and it gave me error message... pg_atoi... :(
but it worked inserting by parts of the file...
thanx,
Rocael.
_
