[pgadmin-support] How to import data

Hi, i have data in MS Excel.Now i need to export data from excel to pgsql table.Is there any posiblity to this   Thanks  &  Regards Vivekananda.R | Software Engineer    Infinite Computer Solutions | Exciting Times…Infinite Possibilities... SEI-CMMI level 5 | ISO 9001:2000

[pgadmin-support] Convert excel data from pgsql data

I have data in excel like... C:\vivek\stddtls.xls Sno Name class marks --- - -- -- B3091 Ram 10 76% B3092 siva 10 74% ... ... .. ... Now I have table in PGSQl like Sno Name gender class marks Address -- - - Now I need to export the data from excel to

[pgadmin-support] How to find out hierchy of employee?

Hai, I have proper knowledge in Oracle 9i as wel as PostgreSQL. I have written a query in Oracle-SQL like the following...   select level,substr(lpad(' ',level*2)||ename,1,20) name from emp start with ename='KING' connect by prior empno=MGR; / LEVEL    NAME --   

[pgadmin-support] About decode function

Hi, I have knowledge in Oracle.Now we are using postgresql...,   In oracle... select decode(sex,'M','Male','F','Female') from std; It retuns Male or Female.insted of M or F.   Now i want to use this function in postgresql?is there any posibility? please send me..,i am waitning for ur repl

[pgadmin-support] How to install ODBC driver

  Hi, I need to export data from Excel to Postgres. But i dont know how to install the ODBC driver? From where shall get this driver?   Please tell me.. Thanks  &  Regards Vivekananda.R | Software Engineer    Infinite Computer Solutions | Exciting Times…Infinite Possibiliti

[pgadmin-support] How to cal function in in another function

Hi, i have written these functions,please go through this...   table emp: It contains   empno ename   mgr    sal  dept - 22    swarna   23 2600    2

[pgadmin-support] How to provide db access to other systems

  Hi, We are using J2EE with PostgresSQL 8.1.0. OS : Wind In my system,i am having Postgre database.Now i want to provide database access to the front-end programmers. How can i do that? Please give me and explain the path...because we dont have any DBA.. Im the new one for PostgreSQL Th

[pgadmin-support] How to access table from one database to another database

  hi, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas named Public,cao,sts,reports   Now  i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. How it is posible.   2nd thing is...   i have 2 serv

[pgadmin-support] how to use lo_import function

hai, My system IP Address is 172.16.9.73 I am accessing database from server..i.e172.16.5.179 Now,i want use lo_import and lo_export functions storing and retriving bitmap images...       while executing this query...   In local database: -- update imprest_holder set s

[pgadmin-support] How to access a table from one database to another database

Hai all, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas named Public,cao,sts,reports   Now  i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. How it is posible.   2nd thing is...   i have 2

[pgadmin-support] How to use lo_export and lo_import

Hi, I have PostgresSQL database connection from server. Server ip is 172.16.5.179 Now I want use lo_import and  lo_export function for storing images into the database. This images is located in my system itself. When I am going using the following query… Insert into image values('chan

[pgadmin-support] How to access table from one database to another database

Hai all,  I have 2 databases namee PAO and CAS.  PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas  named Public,cao,sts,reports    Now  i am in PAO database..now i want access table 'activity' in  schema 'cas' in CAS database.  How it is posible.    2nd thing is

[pgadmin-support] UNSUBSCRIBE

Hi.. Please unsubscribe me. Thanks Vivek.R Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged,