Re: [GENERAL] Schema Information .

2017-12-05 Thread Melvin Davidson
On Tue, Dec 5, 2017 at 4:09 AM, Brahmam Eswar wrote: > Thanks David for your quick response. > > I'm using below query to pull the schema information ,but the count of > rows in table is giving wrong ,i can see the count of records using select > count(*) from . How do we get an exact number of

Re: [GENERAL] Schema Information .

2017-12-05 Thread Brahmam Eswar
Thanks David for your quick response. I'm using below query to pull the schema information ,but the count of rows in table is giving wrong ,i can see the count of records using select count(*) from . How do we get an exact number of rows in table. SELECT C.relname AS Table_Name, C.relnatts AS

Re: [GENERAL] Schema Information .

2017-12-04 Thread Melvin Davidson
On Mon, Dec 4, 2017 at 9:17 AM, Brahmam Eswar wrote: > Hi , > > Is there anyway to pull the complete information of tables in a particular > schema . > > Table_Name ,Num_Rows,Columns,Indexed_Columns,Triggers. > > > > The context of this request is ,we are migrating the database from Oracle > to P

[GENERAL] Schema Information .

2017-12-04 Thread Brahmam Eswar
Hi , Is there anyway to pull the complete information of tables in a particular schema . Table_Name ,Num_Rows,Columns,Indexed_Columns,Triggers. The context of this request is ,we are migrating the database from Oracle to PostgreSQl,,so we need to verify the data after perform data migration fr