I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each query result, which is a pain in the butt.
That is not correct. As long as the table definitions are precisely
the same, you can move records across dblink without specifying
fields. You do this
On Thursday 01 September 2011 11:47:24 Sim Zacks wrote:
Is there a way to get an md5 or other hash of an entire table?
I want to be able to easily compare 2 tables in different databases.
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each
Is there a way to get an md5 or other hash of an entire table?
I want to be able to easily compare 2 tables in different databases.
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each query result, which is a pain in the butt.
If I could return
On Thu, Sep 01, 2011 at 11:47:24AM +0300, Sim Zacks wrote:
Is there a way to get an md5 or other hash of an entire table?
I want to be able to easily compare 2 tables in different databases.
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each
md5 has size limitations, the second approach seems more practical.
Στις Thursday 01 September 2011 12:30:45 ο/η Karsten Hilbert έγραψε:
On Thu, Sep 01, 2011 at 11:47:24AM +0300, Sim Zacks wrote:
Is there a way to get an md5 or other hash of an entire table?
I want to be able to easily
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1
postgres=# select md5(array_to_string(array_agg(md5(tt::text)),'')) from tt;
md5
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1
postgres=# select
I am not sure if this will work, but you can try it
http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks#Cast_to_varchar
Pavel
I appreciate your help, but UDTs don't have input/ouput functions
unless you define them manually and I need this for all of
On 09/01/2011 01:35 PM, Grzegorz Jaśkiewicz wrote:
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
On Thu, Sep 1, 2011 at 3:48 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
md5 has size limitations, the second approach seems more practical.
Really? I was not aware of size limits of md5, what are they?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Στις Thursday 01 September 2011 15:50:21 ο/η Scott Marlowe έγραψε:
On Thu, Sep 1, 2011 at 3:48 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
md5 has size limitations, the second approach seems more practical.
Really? I was not aware of size limits of md5, what are they?
2011/9/1 Grzegorz Jaśkiewicz gryz...@gmail.com:
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1
OP:
I thought about using dblink and the EXCEPT query, but then I need to know the
field list of each query result, which is a pain in the butt.
That is not correct. As long as the table definitions are precisely
the same, you can move records across dblink without specifying
fields. You
2011/9/1 Merlin Moncure mmonc...@gmail.com:
2011/9/1 Grzegorz Jaśkiewicz gryz...@gmail.com:
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert
2011/9/1 Sim Zacks s...@compulab.co.il:
OP:
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each query result, which is a pain in the butt.
That is not correct. As long as the table definitions are precisely
the same, you can move records
On Thu, Sep 1, 2011 at 7:56 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
Στις Thursday 01 September 2011 15:50:21 ο/η Scott Marlowe έγραψε:
Really? I was not aware of size limits of md5, what are they?
sorry, i was wrong. i dont know why i had this impression,
just checked
16 matches
Mail list logo