| From: | Scott Goldstein <sdgoldst(at)MailAndNews(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | FWD: OID |
| Date: | 2001-04-07 01:11:38 |
| Message-ID: | 3AEC8150@MailAndNews.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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."
------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | GH | 2001-04-07 02:28:39 | Re: FWD: OID |
| Previous Message | Rod Taylor | 2001-04-06 23:51:02 | Re: update tables in remote db using trigger |