: Re: [SQL] Schema partitioning
On Sep 1, 2011, at 14:13, Charlie wrote:
> Could I get feedback from the community on schema partitioning?
>
> I'm doing maintenance on my ddl and I'm noticing that my tables are all in 1
> schema, but they have prefixes on their names lik
On Sep 1, 2011, at 14:13, Charlie wrote:
> Could I get feedback from the community on schema partitioning?
>
> I'm doing maintenance on my ddl and I'm noticing that my tables are all in 1
> schema, but they have prefixes on their names like table_app1_sometable,
> table_app1_secondtable, ta
Hi,
chester c young wrote:
has anyone done any work on comparing schemas?
There are two different projects called 'pgdiff', you'll find them with
google.
I'm trying to automatically propagate changes in a master schema to
child schemas. All schema changes will originate at master. Curren
On 1/22/07, Marcin Stępnicki <[EMAIL PROTECTED]> wrote:
Dnia Mon, 22 Jan 2007 17:38:09 -0200, Ezequias Rodrigues da Rocha
napisał(a):
> Hi list,
>
> I would like to ask you if there is any schema that someone can send me.
I
> must make some Replication testes and would like to use a simple sche
Dnia Mon, 22 Jan 2007 17:38:09 -0200, Ezequias Rodrigues da Rocha
napisał(a):
> Hi list,
>
> I would like to ask you if there is any schema that someone can send me. I
> must make some Replication testes and would like to use a simple schema
> with two or three tables would be nice.
You can find
Kyle,
Nice to hear from you guys again! Action Target was one of the pioneers
of production open source in manufacturing; nice to know that you're
still doing well with it.
--Josh
---(end of broadcast)---
TIP 9: In versions below 8.0, the plan
If it is for multiple columns' foreign key constraint.
Try this query:
SELECT DISTINCT n.nspname AS from_schema_name, c.relname AS
from_table_name, toSchemaName.nspname AS to_schema_name, toTable.relname
as to_table_name,
fk_col.attname
FROM pg_catalog.pg_class AS c
LEFT JOIN pg_namespace AS
Subject: Re: [SQL] schema inspection
O [EMAIL PROTECTED] έγραψε στις Mar 16, 2006 :
> Hi,
>
> supposing to have a small DB:
>
> TABLE a (
> id SERIAL PRIMARY KEY
> );
>
> TABLE b (
> id SERIAL PRIMARY KEY,
> idA INTEGER NOT NULL REFERENCES a(id)
>
>Well thats it if you use only *single column* Foreign keys.
>In the general case the above will need extra work.
Are you sure? I have tested query with 3 table with multiple FK and
it works (see below) [as you can see
"C" table have two FK to A and B]
test=> SELECT
test-> (SELECT relname FRO
>
>SELECT c1.relname,c2.relname from pg_constraint cons,pg_class c1,
pg_class
>c2 where cons.conrelid=c1.oid and cons.confrelid = c2.oid;
>
>for column(s) names you will have to do extra homework.
Thanks! I have obtained my query! Here is:
SELECT
(SELECT relname FROM pg_catalog.pg_class WHE
O [EMAIL PROTECTED] έγραψε στις Mar 17, 2006 :
> >
> >SELECT c1.relname,c2.relname from pg_constraint cons,pg_class c1,
> pg_class
> >c2 where cons.conrelid=c1.oid and cons.confrelid = c2.oid;
> >
> >for column(s) names you will have to do extra homework.
>
> Thanks! I have obtained my query!
O [EMAIL PROTECTED] έγραψε στις Mar 16, 2006 :
> > pg_catalog.pg_constraint is your (only?) friend.
>
> I have already examintated this table without results. Seem not to be
> a "human-readable" table :(
Right you will have to join against pg_class,
and make it readable.
SELECT c1.reln
> pg_catalog.pg_constraint is your (only?) friend.
I have already examintated this table without results. Seem not to be
a "human-readable" table :(
TIA
Roberto Colmegna
Tiscali ADSL 4 Mega Flat
Naviga senza limiti con l'unica Adsl a 4 Mega di velocità a soli 19,95
O [EMAIL PROTECTED] έγραψε στις Mar 16, 2006 :
> Hi,
>
> supposing to have a small DB:
>
> TABLE a (
> id SERIAL PRIMARY KEY
> );
>
> TABLE b (
> id SERIAL PRIMARY KEY,
> idA INTEGER NOT NULL REFERENCES a(id)
> );
>
> How can I inspect pg_schema/information_schema to "detect" the
> rela
Chris Gamache <[EMAIL PROTECTED]> writes:
> So, is the best-practice for the my_schema tables to reference the
> user-defined datatype in the "public" schema?
Not necessarily, but if you put it somewhere else you'll want to add
the somewhere else to your default search path (probably via ALTER
DAT
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> In practice I'm not sure that this is really a situation that we need to
> fret about, because using a datatype that isn't in your search path has
> got notational problems that are orders of magnitude worse than this
> one. The functions and operators tha
Chris Gamache <[EMAIL PROTECTED]> writes:
> Is it even possible to create an index that lives in a different
> schema from the table it is indexing?
It is not --- the index always lives in the same schema as its table.
However, I think that the real issue here is "where is the datatype?".
I'm assu
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Chris Gamache <[EMAIL PROTECTED]> writes:
> > I'm having a heck of a time, and it seems like in my thrashing about
> > to find a solution to this problem I have ruined the uniqueidentifier
> > datatype in the schema...
>
> > CREATE INDEX mt_uuid_idx
> >
Chris Gamache <[EMAIL PROTECTED]> writes:
> I'm having a heck of a time, and it seems like in my thrashing about
> to find a solution to this problem I have ruined the uniqueidentifier
> datatype in the schema...
> CREATE INDEX mt_uuid_idx
> ON my_schema.my_table USING btree (my_uuid);
> ERROR:
look here
http://sql-info.de/postgresql/schemas.html
On Sun, 16 Nov 2003 13:05:20 +0530
Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> hi
> where can i find infor about 'schema' in postgresql?
---(end of broadcast)---
TIP 2: you can get off all li
Charlie Toohey <[EMAIL PROTECTED]> writes:
> Why can't my primary user (ttvuser) access tables (owned by owneruser) for
> which they've been granted access? I can describe the table, but can't
> read it.
> ttvdev=> select count(*) from owneruser.users;
> ERROR: owneruser: permission denied
You
21 matches
Mail list logo
