How to make a limited (selective) dump in Postgres?

Question

linux

For example:
mysqldump -uUSER -pPASS --database DATABASENAME -w '1 limit 100' >FILENAME.sql

Answer 1

I found this solution on the Internet (didn't check it myself):
psql -h … -c 'copy (select… from where ...)
to stdout' | psql -h ... -c 'copy from stdin'
taken from archives.postgresql.org/pgsql-general/2011-09/msg00277.php

Answer 2

Create a temporary table and dump only it through -t.