Re: [GENERAL] what is the data type for files(.txt,.doc,.jpeg) in pgsql

[Peter Eisentraut]

rama krishna wrote:
> 1)I need to insert the files in database .So what i have to give the
> data type for that field while creating the table.

bytea -- Look into the documentation for encoding and other handling 
issues.

>  2)I need to perform some action in database before it shutting down
> or before booting of my server.What to do for this situation

Such a thing doesn't exist in PostgreSQL.  You may be able to do this 
with an external tool, but offhand I can't imagine how.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org