Re: getting information of tables and indexes

"srikanthutpala" <srikanthutpala@xxxxxxxxxxxx> · Fri, 12 Aug 2005 10:24:08 +0530

hi

I am srikanth we are r using postgresql. we  are getting the 
fallowing error

com.ibm.ivj.eab.dab.DAException: SELECT_FAILED Unable to load DAMessages ResourceBundle.
Invalid character data 
was found.  This is most likely 
caused by stored data containing characters that are invalid for the character 
set the database was created in.  
The most common example of this is storing 8bit data in a SQL_ASCII 
database.

Can your 
 telll me the reasions for this and possi able solution for this . I am very thank full if your help me in this issue

Regareds
srikanth.

From: Sean Davis [mailto:sdavis2@xxxxxxxxxxxx] 

Sent: Sunday, April 03, 2005 5:28 AM
To: Srikanth Utpala 
(Virinchi); pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  
getting information of tables and indexes

You can query the information schema:

http://www.postgresql.org/docs/8.0/static/information-schema.html

More specifically:

http://www.postgresql.org/docs/8.0/static/infoschema-columns.html

Hope that answers your question.

Sean

  ----- Original Message ----- 
  From: 
  Srikanth Utpala (Virinchi) 

  To: pgsql-general@xxxxxxxxxxxxxx 

  Sent: Friday, April 01, 2005 1:42 
AM
  Subject:  getting information of 
  tables and indexes

  Hi

  I am Srikanth.  I want to get the information about all tables in the 
  existing postgresql . I want list all the tables and its columns information 
  by executing a simple SQL statement like in oracle. We have a view like 
  “user_tab_columns” in oracle to get all the information of  the tables of 
  a user. Can we have nay option like this in postgresql can u help out in 
  this.

  And also I want to get all constraints in the database and also respective 
  parent tables and parent columns for the referential constrains. Please help 
  in this issues.

  I will be thankful to you for your helping in 
this

  Regards,
  Srikanth.Utpala

---------------------------(end of 
  broadcast)---------------------------
TIP 2: you can get off all lists at 
  once with the unregister command
    (send "unregister 
  YourEmailAddressHere" to 
majordomo@xxxxxxxxxxxxxx)