Hi,
You just have to use the read() function directly into your image field.
I think
there is an example into the documentation, perhaps the programmers
guide ?
If not I can send you a perl script which is doing this kind of stuff!
Regards,
Bernie wrote:
> Now that I've stored several jpg's in
I miss . I know the answer is that I can write them myself,
but I don't know where to start or end.
See this construct:
CREATE TABLE gl-amount (
glam_nr int,
period date,
entry_amount numeric(9,0),
PRIMARY KEY (glam_seq,period)
);
CREATE VIEW glam_curmth_v AS
SELECT entry
Hi,
Is there a way to display big integer numbers splitted by periods in
PostgreSQL queries?
Example: 123.456.789 instead of 123456789 .
Thanks in advance
Sebestyén Zoltán <[EMAIL PROTECTE
Hi,
I'm trying to use Postgres DBI, which is Pg, to write a simple cgi script.
But I encounter a problem, hope anyone can tell me how to do, thanks.
For example:
I have two input forms in ex.html, which names are 'id' and 'student'.
I want to insert them into 'course' table in student database b
Hi!
I was using psql to insert data into the database.
I have *.sql files with the necessary scripts, eg:
insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl');
After many inserts... I've got this message:
query buffer max length of 2 exceeded
query line ignored
and then, a fe
I'm designing a database schema and have questions about OID.
First, I assume that OID are system assigned? [yes]
Second, Can I use OID as a primary key? [no]
Third, Is the OID invariant under an import/export process? [no]
Fourth, Can I create table with an OID type for referencing another
table
>I'm designing a database schema and have questions about OID.
> First, I assume that OID are system assigned? [yes]
> Second, Can I use OID as a primary key? [no]
Perhaps in ignorance, I have used the system assigned OID
as a non-topical primary key. In
> I'm designing a database schema and have questions about OID.
>
> First, I assume that OID are system assigned? [yes]
yes - correct assumption
> Second, Can I use OID as a primary key? [no]
yes(qualified) - incorrect assumption
Currently PostgreSQL doesn't really do anything special with prima
I'm new working with posgres.
Is there any GUI to posgresql?
TIA
Paulo ([EMAIL PROTECTED])
Hey there,
One way to execute .sql scripts in your database is this:
psql -e dbname < script.sql
That is how we recreate our databases from a dump file.
"psql -ef script.sql dbname" seems to have the same problem
you were having with the \i command:
query buffer max length of 2 exceeded
Sorry,
I should have been more clear:
> One way to execute .sql scripts in your database is this:
>
> psql -e dbname < script.sql
That should be done from the command line.
> That is how we recreate our databases from a dump file.
>
> "psql -ef script.sql dbname" seems to have the same pro
On Fri, 15 Jan 1999, Bob Dusek wrote:
>Sorry,
>I should have been more clear:
>> One way to execute .sql scripts in your database is this:
>> psql -e dbname < script.sql
>That should be done from the command line.
Yes... I imagined
Anyway, Query Buffer being full I CAN understand..., but
c
On Fri, 15 Jan 1999, Bob Dusek wrote:
>Sorry,
>> One way to execute .sql scripts in your database is this:
>> psql -e dbname < script.sql
>> good luck,
>> Bob
Ohh... sorry... I forgot to thank you! Thank you... :)
Silvio Emanuel Nunes Barbosa de Macedo
mailto:[EMAIL PROTECTED]
I spent a good part of tonight migrating data from the old to new
database, so we are up to 66 projects that are listed...
I've also started to work on adding stats to the page, so that you can see
the break down of Operating System used, PostgreSQL Version used and
Country...
h
14 matches
Mail list logo
