Mr. Escano, Hi! I found a few articles in
http://techdocs.postgresql.org/ that might just be able to help you. MySQL's binary data type is equivalent to PostgreSQL's bytea data type. If you store large objects in MySQL using its binary data type, you might consider PostgreSQL's lo data type instead of bytea. Please see the README.lo file from the postgresql-contrib package. Tables, indexes, constraints, triggers, functions, etc. are treated as objects in PostgreSQL. You can think of a schema as a container for these objects. The PUBLIC schema contains objects that are publicly accessible. A convention you might want to try is to make schemas whose names are equal to their respective owners. E.g. (PostgreSQL 7.4.7 example) CREATE USER tito ENCRYPTED PASSWORD 'titopassword'; CREATE SCHEMA tito AUTHORIZATION tito; SHOW search_path; search_path -------------- $user,public (1 row) >From this point onwards, the next time user TITO logs in, all database objects he creates/references in his SQL statements will be created/searched in the TITO schema. If the object (e.g. table) cannot be found in the TITO schema, the PUBLIC schema will then be searched. As a security measure, it would be best to place objects in private (non-PUBLIC) schemas. It would force you to explicitly grant priviliges to other users. I'd love to do more seminars on PostgreSQL. The first (and hopefully not the last) was in the most recent PLUG Technical Seminar. Charlton "Charlie" H. Lopez Novell Certified Linux Professional --- Tito Mari Francis Esca�o <[EMAIL PROTECTED]> wrote: > Good day! > > I need pointers about database schema and data > migration from MySQL to > PostgreSQL. What's the equivalent or counterpart of > MySQL's 'binary' > data type? > > Any scripts you can recommend for faster migration > from one to the > other. I tried my2pg Perl script but it seems > limited, it reported > error after some time. > > Thanks for the advice in advance. > > -- > Tito Mari Francis H. Esca�o > Computer Engineer and GNU/Linux Proponent > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > [email protected] (#PLUG @ irc.free.net.ph) > Read the Guidelines: http://linux.org.ph/lists > Searchable Archives: http://archives.free.net.ph > ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
