How should I free memory after I allow FETCH ALL statements in a C
program to auto-allocate memory? I assume that it's OK to use a simple
free statement to free memory allocated for an array of values (e.g., an
array of float values). But what about memory allocated for and
associated with an a
On 2009-04-29, Nicholas I wrote:
> --000e0cd1d5062f2ca40468abd813
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> can anybody me suggest me, how to compare two tables of different
> database.
you want to use a join but can't...
you need to get both
Can't you use this?
select name from database2.sr_1 where name not in (select name from
database2.pr_1);
My test database VM isn't running so I can't test it, but I seem to remember
that that's how I did it for a few queries of that type. This is assuming
the 2 databases are running on the
On Thu, Apr 30, 2009 at 08:20:02AM +1000, Adam Ruth wrote:
>The simple answer is to pg_dump both tables and compare the output with
>diff.
>Other than that, I think you'll need a custom program.
For all but the strictest definition of "identical", that won't work.
Tables may easily con
2009/4/29 Nicholas I :
>
> can anybody me suggest me, how to compare two tables of different
> database.
>
Two PostgreSQL databases: dblink
http://www.postgresql.org/docs/current/interactive/dblink.html
Distinct DBMS: dbilink
http://pgfoundry.org/projects/dbi-link/
Osvaldo
--
Sent via pgsql
Hi All,
For example,
There are two database. database1 and database 2;
database1 has a table called pr_1 with the columns, id,name and time.
database2 has a table called sr_1 with the_columns id,name and time.
i would like to find out the differences that is, find the nam
On 2009-04-29, Nicholas I wrote:
> --000e0cd1d5062f2ca40468abd813
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> can anybody me suggest me, how to compare two tables of different
> database.
you probably want to use some sort of join.
--
Sent via
