On 3/5/2013 2:03 AM, Stefan Keller wrote:
Hi
Oracle defines database (schema) objects and "non-schema" objects (see [1]).
Is there also such a thing in Postgres?
Yes. See, for example, CREATE USER, CREATE TABLESPACE and CREATE SCHEMA.
--
Guy Rouillier
--
Sent via pgsql-general mailing lis
Hi
Oracle defines database (schema) objects and "non-schema" objects (see [1]).
Is there also such a thing in Postgres?
Yours, Stefan
[1] http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements007.htm
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
Andreas Kretschmer wrote:
> Albe Laurenz wrote:
>> Dhiraj Gupta wrote:
>>> I have created a database name '"ofbiz". then the default schema name
>>> "public "
>>> created automatically. I want to create schema name ofbiz in the database
>>> "ofbiz"
>>> when I create database name "ofbiz" then
Albe Laurenz wrote:
> Dhiraj Gupta wrote:
> > I have created a database name '"ofbiz". then the default schema name
> > "public "
> > created automatically. I want to create schema name ofbiz in the database
> > "ofbiz"
> > when I create database name "ofbiz" then the schema name "ofbiz" will
Dhiraj --
>
> From: Dhiraj Gupta
>To: pgsql-general@postgresql.org
>Sent: Sunday, December 2, 2012 9:35 PM
>Subject: [GENERAL] Database schema
>
>
> Hi All,
>I have created a database name '"ofbiz". then th
Dhiraj Gupta wrote:
> I have created a database name '"ofbiz". then the default schema name
> "public "
> created automatically. I want to create schema name ofbiz in the database
> "ofbiz"
> when I create database name "ofbiz" then the schema name "ofbiz" will create
>automatically.
> how it
> I have created a database name '"ofbiz". then the default schema name
> "public " created automatically. I want to create schema name ofbiz in the
> database "ofbiz"
> when I create database name "ofbiz" then the schema name "ofbiz" will
> create automatically.
> how it is possible if yes,
Pre
Hi All,
I have created a database name '"ofbiz". then the default schema name "public "
created automatically. I want to create schema name ofbiz in the database
"ofbiz"
when I create database name "ofbiz" then the schema name "ofbiz" will create
automatically.
how it is possible if yes,
Tha
On Monday 29 June 2009, fe...@crowfix.com said something like:
> I'd like to dump a database schema to a file, probably XML but
> anything reasonable is good enough. By "schema", I don't mean the
> narrow postgres keyword, but rather the table names, columns,
> foreignkeys, triggers, constraints,
Hi
Try Mogwai ERDesignerNG. it can reverse engineer databases like
Postgres, Oracle, MySQL, MSSQL, stores its model as XML files and can
also generate DDL from it.
Supporting schema comparison, schema evolution and data dictionaries.
Regards
Mirko
fe...@crowfix.com schrieb:
I'd like to dump
On Tue, Jun 30, 2009 at 12:21:22AM +0200, Thomas Kellerer wrote:
> Take a look at my SQL Workbench/J, especially the WbReport command:
>
> http://www.sql-workbench.net/index.html
>
> http://www.sql-workbench.net/manual/wb-commands.html#command-schema-report
That just may do the trick. I'll exp
On Mon, Jun 29, 2009 at 04:32:46PM -0600, Scott Marlowe wrote:
> Have you tried pg_dump -s yet?
We I know I said the format is immaterial, and I know I could
write something to convert it into something more useful, but it is on
the low end of what I was looking for, and is very much Pos
On Mon, Jun 29, 2009 at 4:08 PM, wrote:
> I'd like to dump a database schema to a file, probably XML but
> anything reasonable is good enough. By "schema", I don't mean the
> narrow postgres keyword, but rather the table names, columns,
> foreignkeys, triggers, constraints, etc.
>
> I'd really li
fe...@crowfix.com wrote on 30.06.2009 00:08:
I'd like to dump a database schema to a file, probably XML but
anything reasonable is good enough. By "schema", I don't mean the
narrow postgres keyword, but rather the table names, columns,
foreignkeys, triggers, constraints, etc.
I'd really like so
I'd like to dump a database schema to a file, probably XML but
anything reasonable is good enough. By "schema", I don't mean the
narrow postgres keyword, but rather the table names, columns,
foreignkeys, triggers, constraints, etc.
I'd really like something that could work for other databases too
On Wed, Jan 21, 2009 at 05:18:57AM +0100, Együd Csaba wrote:
> >From: David Fetter [mailto:da...@fetter.org]
> >On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
> >> Hi,
> >> I'd like to ask your suggestions about a reliable admin software
> >> which is able to compare two dabases and g
>dbsolo does a decent job.
>I think they main thing here is to check for inconsistencies and see
>what they are, rather
>then a tool that takes over the administrative task.
>
>We all understand David's point of view, but it can't hurt to have a
>tool in place that can verify the consistency of bot
On Jan 20, 2009, at 11:27 PM, Együd Csaba wrote:
-Original Message-
From: Robert Treat [mailto:xzi...@users.sourceforge.net]
Sent: Wednesday, January 21, 2009 3:51 AM
To: pgsql-general@postgresql.org
Cc: David Fetter; Csaba Együd
Subject: Re: [GENERAL] Database schema &
>-Original Message-
>From: Robert Treat [mailto:xzi...@users.sourceforge.net]
>Sent: Wednesday, January 21, 2009 3:51 AM
>To: pgsql-general@postgresql.org
>Cc: David Fetter; Csaba Együd
>Subject: Re: [GENERAL] Database schema & data synchronizer software for
>Pos
>-Original Message-
>From: David Fetter [mailto:da...@fetter.org]
>Sent: Tuesday, January 20, 2009 4:44 PM
>To: Csaba Együd
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Database schema & data synchronizer software for
>PostgreSQL?
>
>On Tue, J
On Tue, Jan 20, 2009 at 09:51:25PM -0500, Robert Treat wrote:
> On Tuesday 20 January 2009 10:44:06 David Fetter wrote:
> > On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
> > > Hi,
> > > I'd like to ask your suggestions about a reliable admin software
> > > which is able to compare tw
On Tuesday 20 January 2009 10:44:06 David Fetter wrote:
> On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
> > Hi,
> > I'd like to ask your suggestions about a reliable admin software
> > which is able to compare two dabases and generate a schema
> > synchrinizer script.
>
> There is no
On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
> Hi,
> I'd like to ask your suggestions about a reliable admin software
> which is able to compare two dabases and generate a schema
> synchrinizer script.
There is no such thing, and there is no prospect of there ever being
such a thin
Hi,
I'd like to ask your suggestions about a reliable admin software which is
able to compare two dabases and generate a schema synchrinizer script.
It would be nice to be able to generate data synchronization script for only
the selected tables, and other features.
Thank you,
--
Best Regards,
Thanks for the info, everyone.Tomislav
Hi,
This is precisely what I'm after .. could you possibly give me an
example ?
Kind Regards
Paul Newman
-Original Message-
From: Jim Nasby [mailto:[EMAIL PROTECTED]
Sent: 08 March 2006 22:18
To: Michael Glaesemann
Cc: Tomi NA; pgsql-general
Subject: Re: [GENERAL] database/schema
There's nothing like that, but the good news is that you can have
multiple triggers call the same trigger function, and it wouldn't be
*too* hard to script the creation of all those triggers based on the
info in information_schema.tables.
On Mar 8, 2006, at 9:02 AM, Michael Glaesemann wrote
Please remember to cc the list. I'm forwarding this to the list in
case someone has any suggestions.
On Mar 8, 2006, at 23:53 , Tomi NA wrote:
On 3/8/06, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On Mar 8, 2006, at 22:11 , Tomi NA wrote:
> Does anything like that exist in postgresql?
> I
On Mar 8, 2006, at 22:11 , Tomi NA wrote:
Does anything like that exist in postgresql?
It'd rid me of a whole lot of work if it did...and I'd still have
plenty more to keep me busy. :)
What do you mean by database/schema level triggers? Could you give an
example of what you're trying to d
Does anything like that exist in postgresql?It'd rid me of a whole lot of work if it did...and I'd still have plenty more to keep me busy. :)TIA,Tomislav
30 matches
Mail list logo
