Hi All,

Is there a way to protect a database so that the structure cannot be seen?

I would like to use postgresql for data storage in a product I am
working on. The challenge is that most of the value of the product will
be in the database structure itself (data model, functions, etc.). I
want to prevent people from seeing anything while still allowing the GUI
to get at the data.

Is there a way to do this? URLs to relevant documentation are welcome.

--

Kind Regards,
Keith

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On 8/24/06, Keith Worthington <KeithW@narrowpathinc.com> wrote:
> Hi All,
>
> Is there a way to protect a database so that the structure cannot be seen?
>
> I would like to use postgresql for data storage in a product I am
> working on. The challenge is that most of the value of the product will
> be in the database structure itself (data model, functions, etc.). I
> want to prevent people from seeing anything while still allowing the GUI
> to get at the data.
>
> Is there a way to do this? URLs to relevant documentation are welcome.
I don't think you can - not via postgres-means, anyway.

If you think about it - the server process needs to be able
to access those structures; if they were munged it couldn't.

> --
>
> Kind Regards,
> Keith

Cheers,
Andrej



--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Wed, Aug 23, 2006 at 14:39:01 -0400,
Keith Worthington <KeithW@NarrowPathInc.com> wrote:
> Is there a way to protect a database so that the structure cannot be seen?

Not if it is running on computers you don't control.

> I would like to use postgresql for data storage in a product I am
> working on. The challenge is that most of the value of the product will
> be in the database structure itself (data model, functions, etc.). I
> want to prevent people from seeing anything while still allowing the GUI
> to get at the data.
>
> Is there a way to do this? URLs to relevant documentation are welcome.

Host the data on servers you control.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match