And to get the structure of a table, you can use
pg_describe_object(catalog_id, object_id, object_sub_id)
On Fri, Dec 18, 2015 at 10:16 AM, Adrian Klaver
wrote:
> On 12/17/2015 09:28 AM, anj patnaik wrote:
>
>> Currently, I am running pg_dump on an entire table of a database by doing:
>>
>> PG
On 12/17/2015 09:28 AM, anj patnaik wrote:
Currently, I am running pg_dump on an entire table of a database by doing:
PGPASSWORD=$PGPASSWORDB /opt/data/PostgreSQL/9.4/bin/pg_dump -t
RECORDER -Fc $i -U pguser -Z0 | xz -9 > "$backup_dir/$i-$timeslot-database"
However, this table has a lot of ro
Currently, I am running pg_dump on an entire table of a database by doing:
PGPASSWORD=$PGPASSWORDB /opt/data/PostgreSQL/9.4/bin/pg_dump -t RECORDER
-Fc $i -U pguser -Z0 | xz -9 > "$backup_dir/$i-$timeslot-database"
However, this table has a lot of rows.
Is there a way I could do pg_dump on a su
