Search Postgresql Archives

Re: database design questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



on 4/3/06 7:38 AM, ottavio@xxxxxxxxxxxxx purportedly said:

> 1) The database I'm going to develop is  a big list with a catalog of
> items and I  want to  store subsets  of this  list representing  the
> available items in several places.
> 
> My idea  is to create the  big table with  all the elements and  then to
> create another  table, where each  row holds a pair  (id_item, id_place)
> and  thanks to  this create  several views,  joining the  two tables
> and selecting the rows with a give id_place.
> 
> Do you think it's too heavy? Is there a simpler way to do it?

On the surface, perhaps. Depending on your implementation details, you may
be adding unnecessary overhead. No one can really say since we don't know
what you are trying to accomplish.

> 2) do you think it's possible in  a plpgsql procedure select the name of
> a table into a variable and use that variable in the query?
> 
> I mean, can I do something like
> 
> SELECT INTO table_name get_table_name();
> SELECT * FROM table_name;

Yes, kind of. I.e., you can probably do what you want but not with the
syntax you are showing. See SELECT INTO and EXECUTE in chapter 36 of the
online docs. 

> 3) faq 4.11.1 says
> 
>>    CREATE TABLE person (
>>        id   SERIAL,
>>        name TEXT
>>    );
>> 
>> is automatically translated into this:
>> 
>>    CREATE SEQUENCE person_id_seq;
>>    CREATE TABLE person (
>>        id   INT4 NOT NULL DEFAULT nextval('person_id_seq'),
>>        name TEXT
>>    );
> 
> how can I do it with a INT8 instead of a INT4?


Use BIGSERIAL instead.

Best,

Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux