Skip site navigation (1) Skip section navigation (2)

Re: Database organization questions

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: matty jones <urlugal(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Database organization questions
Date: 2011-06-25 00:15:41
Message-ID: 4e0528b4.242a440a.22b2.2bb5@mx.google.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Jun 16, 2011 at 08:50:30AM -0400, matty jones wrote:
> I am going to be setting up OTRS, a help desk application, and the backend
> is going to be Postgres, along with this I need to create
> a separate application to track whether or not a customer has a service
> contract with us and the type of service contact.  The question I have is
> that the service application will have a table that stores the customer's
> contact information, and OTRS also has this table, is there a way I can
> share this table between these two applications?

Do the two applications have the same concept for this table? In other words,
do they both expect the same table structure, field names, data types, field
order, indexing, etc.? If not, it will be pretty tough to get them to share
the table.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

In response to

Responses

pgsql-novice by date

Next:From: Roy's EmailDate: 2011-06-25 07:05:11
Subject: Linking libpq.lib with VC++
Previous:From: Jean-Yves F. BarbierDate: 2011-06-22 21:55:29
Subject: Re: seeking advices for function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group