[GENERAL] How to Describe a field in the table???

2001-03-04 Thread Boulat Khakimov
Hi, Im porting my programs from mySQL to PG. mySQL supports a query "DESCRIBE tablename fieldname" , that provides a detailed description of a specific table field. Is there such an equivalent in PG? "\d tablename" gives description for all the fields in the table, however I need to find out a

[GENERAL] Two way encription in PG???

2001-03-04 Thread Boulat Khakimov
Hi, Im porting my software from mySQL to PG. I need to encypt a field in a table using two way encription. In mySQL for those purposes I was using build-in functions ENCODE/DECODE, is there such an equivalent in PG? How do I encrypt/decrypt something in PG? Regards, Boulat ---

Re: [GENERAL] Getting lengths of variable fields

2001-03-05 Thread Boulat Khakimov
ut the "attrelid" if I only know that table name?? That's the only thing that keeps me from getting max field limit for a specific field in a specific table... Regards, Boulat Khakimov -- Nothing Like the Sun ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] List of all system tables.

2001-03-05 Thread Boulat Khakimov
Hi, How do I get the list of all system tables starting with "pg_" Regards, Boulat Khakimov -- Nothing Like the Sun ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send &

Re: [GENERAL] Getting lengths of variable fields

2001-03-05 Thread Boulat Khakimov
Michelle Murrain wrote: > > On Monday 05 March 2001 07:05 pm, Tom Lane wrote: > > Join attrelid against the OID column of pg_class ... > > Um, which column? When I look at that table, I see the following columns... > > relname | reltype | relowner | relam | relpages | reltuples | >

[GENERAL] Blowfish, DESC and etc.

2001-03-09 Thread Boulat Khakimov
Hi guys, I've put encode/decode functions (pg_bf-1.0.tar.gz) for Postgres on my web-site for those who might need them http://boulat.net/pub Regards, Boulat Khakimov -- Nothing Like the Sun ---(end of broadcast)--- TIP 1: subscrib

[GENERAL] Postgres Bug (ALTER TABLE problem)

2001-04-26 Thread Boulat Khakimov
altho it got renamed. Does anyone know a way to fix that problem? Any Feedback would be appreciated... Regards, Boulat Khakimov -- What goes around, comes around ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl