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
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
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
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