I am trying to backup the tiger.loader_platform" table. There are three rows in the table.

I have tried this command on the same same database under the public schema and I am getting insert statements in the outputted sql file "loader.sql"

However when I try it on the tiger.loader_platform I don't get any insert statements.

pg_dump  --table="tiger.loader_platform" --data-only --column-inserts MYDATABASE > loader.sql

The contents of the file is

-- PostgreSQL database dump

-- Dumped from database version 13.0 (Debian 13.0-1.pgdg100+1)
-- Dumped by pg_dump version 13.0 (Debian 13.0-1.pgdg100+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

-- PostgreSQL database dump complete

Any idea why I am not getting the insert statements when I go pg_dump on the tiger.loader_platform table?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.