You may drop or even damage a table in some way. Tables could be damaged for physical reasons, such as disk corruption, or they could also be damaged by running poorly specified UPDATEs/DELETEs, which update too many rows or overwrite critical data.
It's a common request to recover from this situation from a backup.
The methods differ, depending upon the type of backup you have available. If you have multiple types of backup, you have a choice.
LOGICAL (from custom dump
If you've taken a logical backup using
pg_dump into a custom file, then you can simply extract the table you want from the dumpfile like the following:
pg_restore -t mydroppedtable dumpfile | psql
or connect direct to the ...