As an alternative to the other tools - I've had luck using a simple query
that uses information schema.
How Can I do to compare two structures of data bases ?
DBA != DBB I need wich functions and wich tables are not equals
thnks
is working,
you can filter further on the column types. It's pretty simple as long as
you understand joins.
On Thu, Feb 24, 2011 at 10:30 AM, manuel antonio ochoa
manuel8aalf...@gmail.com wrote:
How can I do that ? I dont know how to use the query !! ?
2011/2/24 Isaac Dover isaacdo...@gmail.com
Hi,
While hashing is certainly a good idea, you really should consider some
issues well before you get to that point. Trust me, this could save you some
headaches. First, though you're probably already aware, two XML documents
can be the same document, but with very different literal
tag-value implementation, and likely would if
we thought we were ever going to ask questions like everything with tag
foo value less than ten, but that's not on the table. (Today...)
On 11/30/2010 12:21 PM, Isaac Dover wrote:
Hi,
While hashing is certainly a good idea, you really should
Hello, I am attempting to build an xml representation of any database, but
I'm having trouble doing so. I was interested in using the existing xml
functions, such as schema_to_xmlschema, but the results are strange and
unusable. The resulting schema doesn't even contain the column names, though
it
possibly this answers my question, and what i am doing is indeed the most
appropriate?
Databases are physically separated and access control is managed at the
connection level.
from 8.3 docs, section 20.1
thanks,
Isaac
On Fri, May 22, 2009 at 2:37 AM, Isaac Dover isaacdo...@gmail.com wrote
PM, Tom Lane t...@sss.pgh.pa.us wrote:
Isaac Dover isaacdo...@gmail.com writes:
As far as i can tell,
pg_hba.conf is the only manner in which to prevent users from connecting
to
other users' databases. I've restricted roles to connecting only using
sameuser:
host sameuser all
i've not tried this in postgres, but using information_schema makes
comparing structures of databases trivial. i've been using this query for a
while with MSSQL. Maybe this helps to answer the question.
- isaac
select ST.Table_Name, ST.Column_Name, DV.Table_Name, DV.Column_Name, *
from
schema to be incredibly valuable.
Thanks,
- Isaac
On Sat, May 2, 2009 at 5:25 PM, Lucas Brito luca...@gmail.com wrote:
2009/5/2 Isaac Dover isaacdo...@gmail.com
i've not tried this in postgres, but using information_schema makes
comparing structures of databases trivial. i've been using
hi all, i'm coming from the MS SQLXML world and attempting to learn SQL/XML,
but i'm having some trouble... my first project, which i thought would be
simple, is to create an xml model using the information schema views... i'm
simply trying to build a document such as:
Catalog Name=SomeCatalog
10 matches
Mail list logo