Hi,
I have a number of PostgreSQL servers which I often access through ssh
tunnel with Pgadmin3. I would like to double check which one I have landed
on (if the tunnel is really configured the way I want). Is there a way to
query the hostname from the catalogs?
Thanks
Peter
Folks,
would you like help me how to query this case.
I have tbl_a, the fields are :
item_record
item_product_name
item_qty
if the data are :
item_record = 1,2,3,4,5,6
item_product_name = a,b,a,c,d,c,...
item_qty = 10,5,15,10,20,5,...
How the query to sum item_qty_total if i want the result :
* [EMAIL PROTECTED] (Richard Susanto) wrote:
|
| Folks,
| would you like help me how to query this case.
|
| I have tbl_a, the fields are :
| item_record
| item_product_name
| item_qty
|
|
| if the data are :
|
| item_record = 1,2,3,4,5,6
| item_product_name = a,b,a,c,d,c,...
| item_qty =
On Thu, Aug 25, 2005 at 18:44:00 +0700,
Richard Susanto [EMAIL PROTECTED] wrote:
Folks,
would you like help me how to query this case.
This question is off topic for the pgsql-admin list, it should have been
asked on the pgsql-sql list because it was a question about SQL. (I probably
wouldn't
Hi folks
Any body can help me?
I have six table_product, in @ table_product have field part_number and
product_name, I want to get the part_number and the product_name from the
six table_product. How the query to get the field part_number and the
product_name?
Best Regards,
Richard Sitompul
Richard,
I am not sure if I really understand your question, but.
I think what you want is:
select part_number, product_name from table_product
Again I am not sure if I understand what you are really looking for so if
this is not it ask again.
Enthusiastically,
Dave Leedom
At 04:00 AM
Sorry if you not understand what i mean :D
I have six table_product, for example :
table_product_1
table_product_2
table_product_3
table_product_4
table_product_5
table_product_6
in table_product_1 until table_product_6 have field part_number and
product_name. I want to ask here, how the query to
On Wednesday 04 May 2005 04:09, Richard Sitompul wrote:
Hello Richard!
I have six table_product, for example :
table_product_1
table_product_2
table_product_3
table_product_4
table_product_5
table_product_6
in table_product_1 until table_product_6 have field part_number and
Hi folks,
Thanks for all, I found it. I use this query.
SELECT tbl_product1.part_number, tbl_product1.product_name
FROM tbl_product1
UNION ALL
SELECT tbl_product2.part_number, tbl_product2.product_name
FROM tbl_product2)
UNION ALL
SELECT tbl_product3.part_number,