Hide column in a view? - Mailing list pgsql-novice

From Juliet May
Subject Hide column in a view?
Date
Msg-id 003d01c3042e$f17c2e80$a1d2a8c0@impsu.net
Whole thread Raw
In response to Date Style  (Alan Roberto Romaniuc <romaniuc@klais.com.br>)
Responses Re: Hide column in a view?  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-novice
Is it possible to hide a column in a view so that it is only accessible to
postgresql and no other application. We are syncing a view in postgresql
with an application that does not allow you to create a column with the name
oid, however the psqlodbc driver requires the oid column in order to sync
with the postgresql database. Since the view does not contain the oid or
ctid column I selected them as part of the view definition. This works great
until we try to download the database and create it on the mobile
application.

Thanks for any help you can provide.

Julie


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Date Style
Next
From: "Patrick Hatcher"
Date:
Subject: Re: Hide column in a view?