Aurora PostgreSql-Command

1) PostgreSQL DESCRIBE TABLE using psql

postgres=# \c dvdrental

the command \d table_name or \d+ table_name to describe a table.

To get information on columns of a table, you query the information_schema.columns catalog. For example:

SELECT table_name,column_name, data_type FROM information_schema.columns WHERE table_name = 'city';

With the NUMBER data type without precision and scale in Oracle, we can refer to the following decision matrix based on underlying dataset stored.

Backup of Schema run on below command on windows instance  

C:\Program Files\pgAdmin 4\v5\runtime\pg_dump.exe --file "D:\\folder\\DUMP-PG\\awsdev.backup" --host "auroradbcluster-vlaecluster-rds.amazonaws.com" --port "5432" --username "dms" --no-password --verbose --format=c --blobs  --schema "awsdev" "dms_dev"

Backup of Schema run on below command on Linux instance  

root@ip-100-76 bin]#  pg_dump -h auroradbcluster-vlaecluster-rds.amazonaws.com" -p 5432-U dms dms_dev-n awsdev-v > awsdev.sql

test

test