[ADMIN] How the query please!
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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] How the query please!
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 get the part_number and product_name in one view(product_view). Any body can help me again? 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 5/3/2005, Richard Sitompul wrote: >>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 >> >> >> >> >> >>---(end of broadcast)--- >>TIP 4: Don't 'kill -9' the postmaster > > > > The Hightower Group, Inc. > Custom Software Solutions Designed To Fit Your Business Like A Glove. > 165 West Airport Road, Suite B/Lititz, PA 17543 > V:717-560-4002, 877-560-4002 x: 114 > F:717-560-2825 > www.hightowergroup.com > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faq > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] How the query please!
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, tbl_product3.product_name FROM tbl_product3) UNION ALL SELECT tbl_product4.part_number, tbl_product4.product_name FROM tbl_product4) UNION ALL SELECT tbl_product5.part_number, tbl_product5.product_name FROM tbl_product5) UNION ALL SELECT tbl_product6.part_number, tbl_product6.product_name FROM tbl_product6; > 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 >> product_name. I want to ask here, how the query to get the part_number >> and >> product_name in one view(product_view). > > hm. are you searching for something like this, perhaps? > > create view product_view > as > select > part_number > ,product_name > from table_product_1 > > union > > select > part_number > ,product_name > from table_product_2 > > union > > ... > >> Any body can help me again? > > Is it this what you where searching for? > > HAND && HTH > > Johannes > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- >>Richard Sitompul<< Software Engineer PT. Orbis Indonesia http://www.orbisindonesia.com http://richardsstp.3wsi.net ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Whats the file extention for custom format in pg_dump
You can try pg_dump -U postgres -d -O databasename > databasename.sql Thanks, Richard Sitompul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gourish Singbal Sent: Tuesday, March 01, 2005 14:37 To: PgSQL Admin Subject: [ADMIN] Whats the file extention for custom format in pg_dump can someone tell me the default file compression type for dumps taken using /usr/local/pgsql/bin/pg_dump -b -F c -h -d please any help would be great -- Best, Gourish Singbal ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] how to install pg 8 in windows fat32 partition
Hi Gul, You can install :), but I'm not sure pg8 can be runs in fat32, Because some functions of pg8 not support in fat32. Regards, Richard Sitompul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of guly Sent: Monday, March 07, 2005 10:25 To: pgsql-admin Subject: [ADMIN] how to install pg 8 in windows fat32 partition I want to install pg 8 in my own pc.But my windows partition type is FAT32.When I was installing,There always showed me an error that it only supports NTFS type. Can I install pg8 at FAT32? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
