Hello,
I have some problems entering date fields.
Wether I do:
copy Photographer from 'mydir/db.txt' using delimiters ';';
or insert into Photographer values (1,2,'12-07-1974');
All dates are messed up. The month and day fields are ok, but the year
value changes to something weird like 32768
I have stored IP's in a table using a varchar(15) field. My problem is how
to make the order by list the IP's the correct order like:
192.168.1.1
192.168.1.6
192.168.1.10
now it sorts them like:
192.168.1.1
192.168.1.10
192.168.1.6
is it possible to get them sorted the right way ?
--
Hi,
I have two questions about the copy (SQL or not) command.
If I understood it well, \copy is just an interface to the SQL copy
command.
First of all, it stops if a unique index rule is broken.
This means that one can not insert a set of datas using copy, and
relying on the database's core to
Folks,
Will the lastest ODBC driver support Windows NT? The site for it seems
to indicate that it will only work with Windows 95. I have installed in
on a WinNT machine and it reports that the user cannot log in and that
the authentication type is unknown.
Suggestions?
Thanks,
Jeffrey Lyon
[
Hello,
I wrote a PostgreSQL client (using libpq) which queries 7 different
tables in a database I have constructed using PostgreSQL 6.2.1. The
queries are more or less independent of one another so I thought this
would be more efficient if I did some parallel or multiprocess programming.
The pro
What is wrong ?
Tks, for any help.
% who am i
pgsqlttyp4 Jun 11 23:03
% psql template1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or term
