e query 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 !! ?
>
>
&g
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
en parameter set.
>
> We could also do a manual 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, Is
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 representatio
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
i
9 at 12:31 PM, Tom Lane wrote:
> Isaac Dover 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
> >&
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 wrote:
> H
nformation
schema to be incredibly valuable.
Thanks,
- Isaac
On Sat, May 2, 2009 at 5:25 PM, Lucas Brito wrote:
> 2009/5/2 Isaac Dover
>
>> i've not tried this in postgres, but using information_schema makes
>> comparing structures of databases trivial. i've been usin
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 [database
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:
10 matches
Mail list logo
