Omnis Postgres

Hi Chris,

It sounds like you’re trying to initiate the dump from an existing SQL connection to your server. I’m afraid that won’t work. Instead, you need to launch pg_dump.exe as an application.

Your example looks pretty good for running a standard SQL dump, with these changes:

1. Drop the SELECT keyword
2. You will likely also need the full path to pg_dump.exe
3. Quote both paths
4. Switch back to backslashes

To put it all together:

Launch program “C:MyPathToPostgresbinpg_dump.exe” fasttracksql > “C:UsersAtad DataDesktopAXAXAX.sql”

Alex

> On Nov 4, 2017, at 19:48, Chris Hughes <ataddata@bigpond.net.au> wrote:
>
> Hello I am trying to do and dump of Postgres data file in an object with the
> following code what am doing wrong.
>
>
>
> data base name = fasttracksql
>
> Changed the backslashes to forward.
>
> System = Windows
>
>
>
>
>
> SELECT pg_dump fasttracksql > C:/Users/Atad Data/Desktop/AXAXAX.sql ;
>
>
>
>
>
>
>
>
>
> Chris Hughes
>
>
>
> Copious Data Pty Ltd (Trading as Atad Data)
>
> Unit 8 /3460 Pacific Highway
>
> Springwood QLD 4127
>
> Phone No:- 07 3208 6347
>
> Mobile No:- 0409 263 349
>
> Fax No:- 07 3208 9347
>
> Email:- ataddata@bigpond.net.au
>
> Web Site:- ataddata.com.au
>
>
>
>
>
>
>
>
>
>
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com