good question, one I'd like answered myself! pg_class has the tables, but has other stuff, too, including system tables something like select x.*...

David Briggs

02-18-2011 09:04 AM
David Briggs

I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer...

Virgina Hernandez

01-27-2010 02:33 PM
Virgina Hernandez

Hello Can I find a document on standard SQL-3 (SQL-99) features supported by PostgreSQL ? And the features not supported ? Thank you, Timothy Madden

Timothy Madden

04-21-2009 05:43 AM
Timothy Madden

Greetings all. Let's say I've got a database schema like this (with the all-capital terms in being the table name) in a PostgresSQL DB: = = = = =...

Jeff Nyman

09-09-2008 10:44 AM
Jeff Nyman

Hi, I'm using postgres sql 8.1x anyone can help convert a character varying to int? I have a table with : attribute | character...

RJ

04-18-2008 09:05 PM
RJ

SQL/PostgreSQL newb here ... I would like to have a primary key in a table where the key is numeric, but has a retains leading zeros. The pkey values...

Mark Drummond

10-27-2006 08:48 AM
Mark Drummond

How to select records from a choosen year? Something like this select myfield from mytable where year(myfield)=2006 Regards R. Stormo

none

05-31-2006 06:33 PM
Bent Stigsen

hi i have a wierd problem and i require an equally weird query. 1) backgound Table test: CREATE TABLE main_table ( string_A varchar( 20), string_B...

ashok@kalculate.com

01-21-2006 07:27 AM
Christoph Haller

Dear SQL and plPgSQL gurus, I seek for your wisdom. I have a variable assignment via SELECT INTO in my function, and I want to separate 3 cases: 1)...

Alexander M. Pravking

01-21-2006 07:23 AM
Christoph Haller

running the following script select ('cabal\\' || user_name) into temporary user_access from tbl_user_access where access_profile_id = 4; copy...

Montervino, Mariano

01-21-2006 07:00 AM
Christoph Haller

There should be numerous posts about how to achieve that. Regards, Christoph ---------------------------(end of...

Christoph Haller

01-21-2006 07:00 AM
Christoph Haller

I need some help for which I could not find much help for within the Postgres book I am looking at, or the online tutorial. I don't know if this is...

Ogden

01-21-2006 06:57 AM
Christoph Haller

Sorry about that... try this: CREATE OR REPLACE FUNCTION svp_getparentproviderids (INTEGER) RETURNS SETOF svp_getparentproviderids_uid_type AS...

Richard Rowell

11-22-2004 05:19 PM
Pierre-Frédéric Caillaud

Hi all Just self-explanatory code below -- var1 with default value. CREATE DOMAIN var1_type AS pg_catalog.text DEFAULT...

Passynkov, Vadim

11-22-2004 10:43 AM
Passynkov, Vadim

hi create sequence mysequence; create table foo( id integer default nextval('mysequence'), bla text, wombat integer, foobar date, primary key(id)

Erik Thiele

11-22-2004 08:58 AM
Passynkov, Vadim

Hello friends I have a doubt, Is it possible to insert images into a postgres db. What is its datatype. Is its possible to insert jpeg images. or v...

sreejith s

11-22-2004 08:10 AM
Rod Taylor

hi all, is there a way to determine the session id on a database session? I would need to have a unique number whenever a session is started,...

Riccardo G. Facchini

11-21-2004 10:31 PM
Bruce Momjian

Justine.Cleary (AT) c1data (DOT) com writes: What it's really unhappy about is that you failed to declare the FOR variable; this is causing it to...

Tom Lane

11-21-2004 07:09 PM
Michael Fuhr

Hi all! I'm having a problem with Postgresql 8.0.0-beta4 on a Win2K machine and a particular join. I've got two tables - a list of customers and...

Scott Pederick

11-20-2004 03:51 PM
Tom Lane

--- Rodrigo Carvalhaes <grupos (AT) carvalhaes (DOT) net> wrote: For a char() column, '20' is the maximum of the values that you have inserted,...

Jeff Eckermann

11-20-2004 11:13 AM
Jeff Eckermann

Markus Schaber <schabios (AT) logi-track (DOT) com> writes: You'd deal with that by taking a lock on the old table. Any sort of catalog-munging...

Markus Schaber

11-20-2004 10:36 AM
Tom Lane

I have a function that uses an execute statement to insert data into a table, I do in my implementation of table partitioning. Anyway, I ran into...

Don Drake

11-19-2004 02:03 PM
Gregory S. Williamson

Hi, If anybody can offer better SQL query please. We have table create table group_facility ( group_id integer not null, facility_id integer not...

Igor Kryltsov

11-19-2004 01:23 PM
Mischa Sandberg

Hi All, PostgreSQL 7.4.5 assume this script: --- create table test_table ( id serial,

Riccardo G. Facchini

11-19-2004 11:08 AM
Tom Lane

Hey, I am trying to compare dates in a sql statement. this is what i have tried: SELECT * FROM transactions WHERE shippingdate>2004-06-08...

Nick Peters

11-19-2004 10:05 AM
Guy Fraser

Hi all, I'm trying to understand where the "" is stored when defining a temporary table. whenever a table is created, a record in the pg_class is...

Riccardo G. Facchini

11-19-2004 09:54 AM
Riccardo G. Facchini

I am wondering whether the following two forms of SELECT statements are logically equivalent: SELECT COUNT( DISTINCT table.column ) ... and SELECT...

Thomas F.O'Connell

11-17-2004 01:27 PM
Thomas F.O'Connell

Hi folks. I'm looking at the possibility of implementing a photo gallery for my web site with a tree structure, something like: create table...

Gary Stainburn

11-17-2004 04:00 AM
Achilleus Mantzios

I have a logging application that should produce an entry in the database every minute or so, give or take a few seconds. I'm interested in finding...

Matt Nuzum

11-16-2004 03:43 PM
Pierre-Frédéric Caillaud

Probably there is no direct way get the definition (i could not find one atleast). You can probably write a custom function which gives all columns,...

Goutam Paruchuri

11-16-2004 10:49 AM
Bruno Prévost

Within a function (and therefore within a transaction), if I UPDATE the primary key of a table, the old value remains visible in the child...

Thomas Berg

11-16-2004 12:52 AM
Stephan Szabo

This is what I get with postgres-7.3 (from Redhat Enterprise !!) Here below a select with a regexp ansroc=# explain select * from s12hwdb where...

carex

11-15-2004 11:12 AM
carex

Hi, does postgresql have a datatype 'other' which in hsqldb is an Object? I am trying to convert the table below into postgreSQL 8: create table...

beyaNet

11-14-2004 07:50 AM
Theodore Petrosky

I have two data tables AUTHORS and BOOKS, and one indirection table AUTHOR_BOOKS which allow me to make n:m links. Now I want to create view that...

Jakub Kaniewski

11-14-2004 07:13 AM
Jakub Kaniewski

Is it possible for an UPDATE/INSERT query string to function in such a way that it requires two like fields in different tables to be equal to/'in...

Ferindo Middleton, Jr

11-14-2004 02:47 AM
Karsten Hilbert

pls check this out: http://linux-bangalore.org/2004/talks/shortlist1.php kg ---------------------------(end of...

Kenneth Gonsalves

11-13-2004 12:48 AM
Kenneth Gonsalves

It looks a bit strange that CIDR output depends on datatype it has been casted from: fduch=# SELECT '1.1.1.1'::cidr; cidr ------------ 1.1.1.1/32 (1...

Alexander M. Pravking

11-12-2004 03:31 PM
Alexander M. Pravking

My first time using unicode. Based on reading other messages I think I've got it all setup correctly but still have prob. Running: psql 7.3.6-RH $...

David B

11-12-2004 03:57 AM
Markus Schaber

Is it possible to have another transatction in a transaction??? In the following example the last ROLLBACK is totally ignored(transaction1)....

Andrei Bintintan

11-11-2004 01:31 PM
Stefan Weiss

This is probably a silly question. Our runtime deployment of database servers (7.4) involves some redundant/duplicate databases. In order to compare...

Gregory S. Williamson

11-10-2004 01:32 PM
Michael Fuhr

Hello, I get an error in my log when connecting to postgres server on Windows. Postgres version : 8.0.0-beta4 LOG TEXT 2004-11-10 11:22:47 LOG: ...

Goutam Paruchuri

11-10-2004 12:38 PM
Goutam Paruchuri

Hallo Martin, Martin Knipper wrote: Sorry, no, this doesn't work. It definitely doesn't return the required resultset. It just returns all...

T E Schmitz

11-09-2004 11:12 PM
Dean Gibson

7.4.6 on Linux. I need a way to drop all indexes of a table without knowing the names of the indexes. Say I have a table table1 index1 index2

Giulio Orsero

11-09-2004 01:55 PM
Giulio Orsero

Hi to all, I have the problem that: select lower('MöBÜEL') or select upper('MöBÜEL') are not working well. I read on some forums that there is...

Andrei Bintintan

11-09-2004 11:59 AM
Markus Schaber

Hi All! In one of my application, I would like to implement incremental fetching. The problem is that I would like to run it from a stateless...

Andras Kutrovics

11-09-2004 10:53 AM
Franco Bruno Borghesi

Hello all, 2 questions ! Question 1 Iam trying to load binary data from sql server to postges. Do i have to write a script .. ?? Question...

Goutam Paruchuri

11-09-2004 09:34 AM
Goutam Paruchuri

Hello, I'm sorry I couldn't think up a more precise subject line. I would like to know whether the following can be implemented in SQL: The example...

T E Schmitz

11-09-2004 08:46 AM
T E Schmitz

Hi, I've this data model: CREATE SEQUENCE a_seq START 1; CREATE SEQUENCE b_seq START 1; CREATE TABLE a ( aid integer NOT NULL PRIMARY KEY, aval...

marc ratun

11-09-2004 04:41 AM
marc ratun

Goutam Paruchuri wrote: be inserted - and in my case there will be thousands of inserts made by plperl. I can make a file with the data (and load...

Marek Lewczuk

11-08-2004 01:14 PM
Marek Lewczuk

Is it possbile to schedule jobs in postgres? ______________________________________________________________________ Post your free ad now!...

Chethana Kuloor

11-08-2004 03:36 AM
Kaare Rasmussen