How to take functions backup in postgresql

Question

I am trying to backup the functions in database using the method described here How to take backup of functions only in Postgres. But it is showing error << was unexpected at this time.

The code I typed in the command prompt is given below.

psql.exe -U postgres -At dbname > /path/to/output/file.sql <<"__END__"
SELECT pg_get_functiondef(f.oid)
FROM pg_catalog.pg_proc f
INNER JOIN pg_catalog.pg_namespace n ON (f.pronamespace = n.oid)
WHERE n.nspname = 'public';
__END__

Please help.

also, you could try adding -c just in front of your input redirection ... so ...file.sql -c <<__END__ .... — Loopo
– Loopo, Commented May 26, 2014 at 12:29
just put it all on one line and use -c: psql.exe -U postgres -At dbname -c "your multi-line sql as one line" > /path/to/output/file.sql — Bohemian
– Bohemian ♦, Commented May 26, 2014 at 12:55

jjanes · Accepted Answer · 2014-05-26 19:56:26Z

0

This is a shell problem.

<< is a feature of Unix-like shells, while you seem to be using Windows.

Just save the text of the query into a file and run it with the -f flag.

answered May 26, 2014 at 19:56

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Akhilesh Over a year ago

I placed the query in a text file and used psql -U postgres -d databasename -f D:\q uery.sql >D:/file.sql

Bohemian · Accepted Answer · 2014-05-26 12:57:07Z

0

I'm sure there's a way to do it, but the simplest thing is just supply the sql as one line with the -c option:

psql.exe -U postgres -At dbname -c "SELECT pg_get_functiondef(f.oid) FROM pg_catalog.pg_proc f INNER JOIN pg_catalog.pg_namespace n ON (f.pronamespace = n.oid) WHERE n.nspname = 'public'" > /path/to/output/file.sql

This is also more portable and will work with tools that need one line, like cron etc

answered May 26, 2014 at 12:57

Bohemian♦

427k103 gold badges603 silver badges750 bronze badges

Collectives™ on Stack Overflow

How to take functions backup in postgresql

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related