Hi
I am running postgres 7.02 on Linux and I am having trouble converting a
character string to a date using the "to_date" function.
For example:
select to_char( to_date( '001112', 'YYMMDD'), 'MMDD');
to_char
--
1112
In other words it is defaulting to the year 0 (actually ye
Two thoughts:
1. Did you start the postmaster with "-i" to allow non-local connections?
2. Did you add the remote host to the "pg_hba.conf" file? See:
http://www.postgresql.org/idocs/index.php?client-authentication.html
Kate
postgresql wrote:
> I have started my pg installation using port
I use the Perl DBI module to connect to a postgres data base on the local
system. I don't specify the host name. This is the syntax I use to connect to
the data base:
use DBI;
$dbname = "foo";
$connstr = "dbi:Pg:dbname=$dbname";
$dbh = DBI->connect($connstr);
Kristopher Yates wrote:
> PERL S
I use the Perl DBI module to connect to a postgres data base on the local
system. I don't specify the host name. This is the syntax I use to connect to
the data base:
use DBI;
$dbname = "foo";
$connstr = "dbi:Pg:dbname=$dbname";
$dbh = DBI->connect($connstr);
Kristopher Yates wrote:
> PERL S
e is no such feature in pgsql. Can somebody
confirm this?
Thanks,
Kate Collins
Peter Eisentraut wrote:
> Craig May writes:
>
> > I have two servers running pgsql. Is there a command to transfer the
> > databases
> > between them?
>
> pg_dump and psql. "Back up&q
Try:
select entry_id from tbl_date where date02 is null;
Kate
Web Manager wrote:
> Hello,
>
> I have a problem with PostgreSQL when I try to select or delete an entry
> with an empty date. That's a typical entry
>
> Table tbl_date
> -
> entry_id154
> date_01
