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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: rama krishna <arkr505(at)gmail(dot)com>
Subject: Re: what is the data type for files(.txt,.doc,.jpeg) in pgsql
Date: 2006-02-07 09:58:27
Message-ID: 200602071058.28294.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Olivier Sirven 2006-02-07 10:16:58 strange query runtime
Previous Message superboy143 (sent by Nabble.com) 2006-02-07 09:47:00 query