Understanding Relation Information Programmatically using Postgres SQL

Understanding psql Import Issues: Resolving Sequence and Primary Key Conflicts When Importing SQL Dumps in PostgreSQL