Re: [GENERAL] Public Database of zip code information

i believe that you can get that info from www.allstats.com. we get our zipcode info from them quarterly. mikeo At 05:03 PM 9/20/00 -0700, Adam Haberlach wrote: > Sometime in the past year, someone mentioned a database that >contained zipcode, lat/long, and city information--does

[GENERAL] Cache lookup for language failed 17533070

ull cust_email| varchar(50) | cust_stream | integer | default nextval('cust_stream_seq'::text) br_cycle | integer | cust_qr_reports | varchar(20) | cust_qr_sent | timestamp | TIA, mikeo

Re: [GENERAL] hidden data fields

you could "hide" or mask columns through views... mikeo At 02:10 PM 8/22/00 -0700, Mike Sears wrote: >>>> In mysql you can make some data apear to be garbled or hiddne, I'm wondering if this can be done using psql? <<<<

Re: [GENERAL] Field names

try this : select attname from pg_attribute where attrelid = (select oid from pg_class where relname = 'your table name') order by attnum; you can further develop a query from this... HTH At 12:14 PM 8/18/00 -0700, Mitch Vincent wrote: >I know this has been asked and answered before but I c

Re: [GENERAL] bytea question

ers\000UNSPECIFIED\000wu_id\000wu_id\000 fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000 what i'm looking to do here is to get the table names and column names out using sql. i can do it in perl with a split command on '\' but was curious as to how to "S

[GENERAL] bytea question

hi all, in the pg_trigger table the tgargs column is defined as type "BYTEA". i can split this up in perl, once retrieved, but can't figure out how to "substring" it in sql. is there an SQL way to select pieces of a column of this type? any help is appreciated, mikeo

Re: [GENERAL] adding column constraint

;d to bill_dist REFERENCES bill_dist (bd_id); # specifies the column in bill_dist to use? yes mikeo At 02:26 PM 7/26/00 -0700, Timothy H. Keitt wrote: >Hmmm... I got it to work, but using a slightly different syntax. Let me >see if I understand your example: > >ALTER T

[GENERAL] drop foreign key

hello, after one has put a foreign key constraint on a table, how can one drop that constraint??? mikeo

Re: [GENERAL] adding column constraint

alter table cust add constraint fk_cust_bd_id foreign key (bd_id) references bill_dist (bd_id); At 12:57 PM 7/26/00 -0700, Timothy H. Keitt wrote: >Can someone give an example of how to add a foreign key constraint to an >existing table? (Pgsql and the man page differ and neither syntax se

[GENERAL] can disks be read only?

d not have the system do an FSCK. one company bought another and we're going to warehouse the purchased company's data for reference. they'll be no additions to it once loaded. thanks, mikeo

Re: [GENERAL] foreign key lost

thanks, i just discovered that before i got your message. now that i have that shovel, maybe i should whack myself with it!!! :) thanks again, mikeo At 02:34 PM 7/7/00 -0400, Tom Lane wrote: >mikeo <[EMAIL PROTECTED]> writes: >> hi, i accidently deleted a foreign key trigger

[GENERAL] foreign key lost

hi, i accidently deleted a foreign key trigger from pg_trigger and now cannot get at the table. i get the message: ERROR: RelationBuildTriggers: 1 record(s) not found for rel feature_code can anyone give me a shovel :) or a little help to get out of this please? TIA, mikeo

Re: [GENERAL] responses to licensing discussion

t;Back to work, folks ... > >--Gene > not being from maryland but, i would think that the constitution's prohibition against ex post facto laws would prevent retro-active applications of laws, if the usa actually followed the constitution; but that's another topic... mikeo

[GENERAL] pg_shadow constraint ?

lems. what i wanted to do was create a "STOP" for attempting to drop a user if that user still owns objects? with a lot of databases i thought it'd be easier for the system to tell me if such a situation existed than my searching through for that info. any suggestions would be welcome! mikeo

Re: [GENERAL] trigger question

At 10:33 AM 6/27/00 -0400, Tom Lane wrote: >mikeo <[EMAIL PROTECTED]> writes: >> CREATE function rates_hist_function() >> returns opaque >> as 'BEGIN >>if ( old.rt_valid <> ''P'' or new.rt_valid not

[GENERAL] trigger question

hen i attempt to insert a row into the rates table using this statement: insert into rates(cut_id,ct_key,rt_valid,...,rt_timestamp,rt_usoc_def_factor) values ('mikeo',123456,'x',...,now(),1.35); i get this error: ERROR: record old is unassigned yet since this trigge

[GENERAL] does vacuum rebuild index?

xxx9 | date| xxx10| integer | xxx11| bigint | the index is on columns 1-5,10,11 thanks, mikeo

Re: [GENERAL] Re: [SQL] oracle rownum equivalent?

e. the point here is moot though, as postgres doesn't have an equivalent and i'll have to learn to live without that small piece of oracle and enjoy what i see as the greater benefits of postgres. :) mikeo

[GENERAL] TOP SESSIONS?

me the same or similar information? TIA, mikeo

[GENERAL] line type

name that table. is it possible to simply "turn off" the line type? any help is appreciated. thanks, mikeo