?

Log in

No account? Create an account
Hello Give me please an example of table dump (made by pg_dump)… - PostgreSQL [entries|archive|friends|userinfo]
PostgreSQL Users

[ website | PostgreSQL Web site ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

[Dec. 20th, 2008|01:42 am]
PostgreSQL Users

postgresql

[sushilshik]
Hello

Give me please an example of table dump (made by pg_dump) which have column with OID type and some bynary data.
linkReply

Comments:
[User Picture]From: pauamma
2008-12-20 01:35 am (UTC)
Did you try creating a PostgreSQL table with those colun types and running pg_dump on it? If you didn't, why? If you did, what happened?
(Reply) (Thread)
[User Picture]From: sushilshik
2008-12-20 03:15 am (UTC)
I did this dump. But table was empty (I didnt put there data). Then i tryed to add data into dump manually in text format like 89504E470D0A1A0A0000000D, but got error on inserting dump into database.

So I need to konvert data from 89504E470D0A1A0A0000000D-format to \\205B\\241P\\245\\245\\224\\0303\\276-format
(Reply) (Parent) (Thread)