Hi,
does anybody know the internal pg_ tables that has
table/column definitions defined (similar to
user_tab_columns in oracle)
thanks,
Shankar
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---
> You mean you want to round off to even seconds? Try
> date_trunc,
> or cast to "timestamp(0) with time zone".
well, i just need to trunc whatever thats after the
timestamp i.e from 06/10/2003 12:50:19.188 PDT, i need
to remove .188 PDT
i'll see if date_trunc helps me or not. thanks for the
s
Shankar K <[EMAIL PROTECTED]> writes:
> some has centiseconds in them along with TZ. Now i'm
> wondering is there a way to just extract date and
> timestamp alone leaving the centisecods as well the TZ
> part.
You mean you want to round off to even seconds? Try date_trunc,
or cast to "timestamp(
<>BEGIN:VCARD
VERSION:2.1
N:Albospino;Héctor A.
FN:Héctor A. Albospino
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20030912T205149Z
END:VCARD
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Thanks, that helped. This is what we did:
(to encode VARCHAR -> BYTEA)
update webuser set ccnum = decode(ccnumstring, 'escape') where userid=userid
(to decode BYTEA -> VARCHAR)
select encode(ccnum, 'escape') from webuser
But what about decrypting with the AES encryption algorithm?
Dylan
-O
On Friday 12 September 2003 20:39, Dylan Milks wrote:
> Hi. Could someone please tell me how to convert a "varchar" to a "bytea"
> datatype.
>
> I have a column which contains a number stored as a varchar. I have another
> column of type bytea. I'm trying to insert the value of the varchar column
>
On Fri, Sep 12, 2003 at 09:53:47AM -0400, David F. Skoll wrote:
> > Note that if you do
> > this very frequently, and you have also to select the summary data,
> > it won't work (as I have learned from painful experience) because
> > the holding table will gradually build up a lot of dead tuples.
>
Hello Marie,
In most of my tables, I have the same
two columns:
lastupdateTIMESTAMP not null default
('now'::text)::timestamp(8),
createdateTIMESTAMP not null default
('now'::text)::timestamp(8)
"crea
Hi. Could someone please tell me how to convert a "varchar" to a "bytea" datatype.
I have a column which contains a number stored as a varchar. I have another column of
type bytea. I'm trying to insert the value of the varchar column in the bytea column,
but the conversion won't work.
Somethin
Marie G. Tuite writes:
> How can I identify table creation date as opposed to last modified?
Not unless you keep track of it yourself.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
oops forgot to mention, database version is 7.3.2
--- Shankar K <[EMAIL PROTECTED]> wrote:
> Folks,
>
> Our databases stores most of the dates as timestamp
> with timezone format, so the data looks like this...
>
> 09/12/2003 12:51:31.268 PDT
> 09/12/2003 12:50:20 PDT
>
> some has centiseconds
Folks,
Our databases stores most of the dates as timestamp
with timezone format, so the data looks like this...
09/12/2003 12:51:31.268 PDT
09/12/2003 12:50:20 PDT
some has centiseconds in them along with TZ. Now i'm
wondering is there a way to just extract date and
timestamp alone leaving the c
On Fri, 12 Sep 2003, pginfo wrote:
> Hi,
> I am runing linux red hat 7.3 (standart install)
> on dual athlon box , 1 GB ram and pg 7.3.4.
>
> If I try to access with pgAdmin one from my tables (i contains ~ 1 M
> records)
> the linux box crashes.
WAIT. Do you mean you get a kernel panic? Or th
How can I identify table creation date as opposed to last modified?
Thanks.
-Marie
---(end of broadcast)---
TIP 8: explain analyze is your friend
Tom Lane wrote:
> pginfo <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> You have a corrupt table. Can you drop and recreate a_acc?
>
> > Yes I can.The problem is that it is happen for 4 times in this week.
>
> Oh? Perhaps you should be looking at the contents of the complained-of
> pages
pginfo <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> You have a corrupt table. Can you drop and recreate a_acc?
> Yes I can.The problem is that it is happen for 4 times in this week.
Oh? Perhaps you should be looking at the contents of the complained-of
pages to try to see what's going on.
Hi,
Tom Lane wrote:
> pginfo <[EMAIL PROTECTED]> writes:
> > In my pg log I can find:
> > ERROR: Invalid page header in block 5604 of a_acc
>
> You have a corrupt table. Can you drop and recreate a_acc?
>
Yes I can.The problem is that it is happen for 4 times in this week.
It is happen on 2 d
unsubscribe pgsql-admin
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Markus Espenhain <[EMAIL PROTECTED]> writes:
> On user who works with the Database create an new record and save this.
> Here the record becomes an ID and another Number from an two sequences.
> One other user ist in this moment working with the database and create an new
> record, too.
> Now he
pginfo <[EMAIL PROTECTED]> writes:
> In my pg log I can find:
> ERROR: Invalid page header in block 5604 of a_acc
You have a corrupt table. Can you drop and recreate a_acc?
> before this error I see also :
> FATAL: Database "template0" is not currently accepting connections
> ERROR: Relation
On Fri, 12 Sep 2003, Andrew Sullivan wrote:
> More or less, yes. The significant part here is that the postmaster
> won't notice that the client is gone until it returns from the work
> it was trying to do. It'll eventually come back, but it'll take some
> time. How low does your contention nee
I didn't see any response to this. Sorry if this is already stale
for you.
On Thu, Sep 04, 2003 at 08:21:17AM -0400, David F. Skoll wrote:
> Questions:
>
> 1) Am I on the right track? Is this how PostgreSQL works?
More or less, yes. The significant part here is that the postmaster
won't notic
Hello all,
I am new here...
I have a Problem by one of our Applications.
The Frontend ist an Access-Application who connects through ODBC to the
postgres-database (7.3.2).
Two of the three Applications works fine. The other have possibly an Problem with
Sequences.
The Problem is the folowing:
unsubsribe pgsql-admin
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
24 matches
Mail list logo
