...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Trinath Somanchi
Sent: Friday, May 14, 2010 3:42 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Postgresql database
Hi All,
I have Tree structured database to maintain.
Its as follows.
Vehicles
|__> Two Wheel
On 05/14/10 13:28, Trinath Somanchi wrote:
yes... But attribute of this table asl has an instance .. that two year
of releases are possible
also... I'm speaking of a very trivial case.
it doesnt multiplies the multitude of table.
it makes no problems with the "joins of ALL the tables"
--
Sent
On Friday 14. May 2010 10.42.17 Trinath Somanchi wrote:
> Hi All,
[snipped]
> This way the data in the table is tree structured. Also A single
> manufacturer has all mode of vehicles. I'm in my way to design this DB for
> use in PgSQL. But for a vast data, data retrieval is a very costly task
> (Jo
yes... But attribute of this table asl has an instance .. that two year of
releases are possible
also... I'm speaking of a very trivial case.
On Fri, May 14, 2010 at 2:44 PM, silly sad wrote:
> On 05/14/10 12:42, Trinath Somanchi wrote:
>
>> Hi All,
>>
>> I have Tree structured database to maint
On 05/14/10 12:42, Trinath Somanchi wrote:
Hi All,
I have Tree structured database to maintain.
Its as follows.
Vehicles
u r talking about a single entity vehicles
it is very common to represent a single entity with a single table
and IF u also have to have an entity "class of vehicles"
u r
Hi All,
I have Tree structured database to maintain.
Its as follows.
Vehicles
|__> Two Wheelers
|__> Manufacturer
|__> Name of Manufacturer
|__> Year of make.
|__> Manuf. Plant.
|__> Model.
|__> Model Name
"Marcos =?iso-8859-1?Q?Aur=E9lio?= S. da Silva" wrote:
>Dear Pg experts,
>
>I have two databases and i want to refer to one table in a database "X"
>when
>i'm using database "Y". Something like this:
>
>select * from X.table
>
>This causes a parse erro
Dear Pg experts,
I have two databases and i want to refer to one table in a database "X"
when
i'm using database "Y". Something like this:
select * from X.table
This causes a parse error. What's the correct sintax?
Best regards,
Marcos Aurelio
Brazil
