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]
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
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
I'm new working with posgres.
Is there any GUI to posgresql?
TIA
Paulo ([EMAIL PROTECTED])
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
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
> 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 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]
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
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
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,
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
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,
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
14 matches
Mail list logo
