FWD: OID

Поиск
Список
Период
Сортировка
От Scott Goldstein
Тема FWD: OID
Дата
Msg-id 3AEC8150@MailAndNews.com
обсуждение исходный текст
Ответы Re: FWD: OID  (GH <grasshacker@over-yonder.net>)
Список pgsql-general
I didn't get a response on my message, so I thought I would try again.

1.  A large object has the data type OID.  What then, is the data type of the
instance object identifier?  Is it an int4?

2.  How would I create a table such the following select statement will return
the instance object indentifier along with the other columns:

SELECT * FROM table_name

Up to this point, I can only retrieve the object instance identifier by doing
the following:

SELECT oid,* FROM table_name

3.  Suppose, from tableA, I wanted a column that references an instance from
tableB.  I would like this reference to contain the instance object identifier
of the instance from tableB.  What data type do I use for this column?  I
suppose this is related to question 1.

Thanks for the help.

Scott

------------------------------------------------------------
"Just a mirror for the sun...
 My smiling eyes are just a mirror for the sun."
------------------------------------------------------------


В списке pgsql-general по дате отправления:

Предыдущее
От: Marc Wrubleski
Дата:
Сообщение: update tables in remote db using trigger
Следующее
От: GH
Дата:
Сообщение: Re: FWD: OID