SELECT table_name, column_name
FROM information_schema.columns
WHERE table_name = 'your_name';
- Original Message -From: hamann w To:
pgsql-general@postgresql.orgSent: Thu, 07 Sep 2017 07:18:12 - (UTC)Subject:
[GENERAL] column names query
Hi,
is there a simple way to retrieve co
...
> Just to add that running psql with the -E switch is REALLY handy for seeing
> how psql executes queries to
> find how tables etc are put together.
I can't actually use that feature to gather the information I'm interested in
since all I have are tables and data with no formal informatio
...snip...
For all tables and columns I get no output at all. Basically I need all tables
and columns for which the column is neither a regular primary key, nor a
foreign key. This will be marked as an attribute in the diagramming program.
Your query for primary keys which are not foreign keys
Hi,
I'm trying to write an application (using libpqxx/C++) which creates graphical
images of large and complex relations between tables (basically an SVG image
with hot spots for drilling down on details). I need to essentially create
icons of tables and their columns, and then draw interconn
Vivek Khera wrote:
"DS" == D Stimits <[EMAIL PROTECTED]> writes:
DS> If it uses the same seed from the connection, then all randoms within
DS> a connect that has not reconnected will use the same seed. Which means
DS> the same sequence will be generated each time, whic
of query and not at
the moment of connect. A pseudo-random generator using the same seed
will generate the same sequence.
D. Stimits, stimits AT comcast DOT net
---(end of broadcast)---
TIP 8: explain analyze is your friend
Iavor Raytchev wrote:
Dear Tom,
We kind of read all documentation we could find, but that was the only way
we could get -
- export db structure into sql file
- export the records we need into another sql file
- import structure
- turn off triggers
- import the records
- turn on triggers
The main pr
Tom Lane wrote:
> "D. Stimits" writes:
>
> >... My question is, where the heck is
> >CurrentMemoryContext and MemoryContextAlloc provided as an
> >implementation which I can link with?
>
>
> They're inside the backend, and you don't --- you a
Joe Conway wrote:
D. Stimits wrote:
> A google search shows very little concerning the pg_detoast_datum
> undefined reference link error. It is looking more like the V1 has to
> be skipped and I'll have to go back to V0 if I can't get this to work.
You haven't shown us
nge to a newer version of PostgreSQL, then a newer version can't
be used]
D. Stimits
---(end of broadcast)---
TIP 8: explain analyze is your friend
Joe Conway wrote:
D. Stimits wrote:
> table field pair. E.G., if I had in table 'one':
> left right
> =
> a b
> a c
> b d
>
> ...then I'd need a list of a, b, c, d, and produce a new table:
> left right
> =
> a
D. Stimits wrote:
I'm using a Redhat version of PostgreSQL 7.2.3 with the C API. Mostly
things work right, but I need more debug output, as I have a query that
works fine from psql, but fails with the C API (perhaps this is because
I use PQescapeString). The only way to know there is an err
12 matches
Mail list logo
