Radicore Forum: How To » Check for empty $schema in dml.psql.class.inc

Home » RADICORE » How To » Check for empty $schema in dml.psql.class.inc

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Check for empty $schema in dml.psql.class.inc [message #7254 is a reply to message #7250]

Thu, 07 February 2019 04:49

AJM
Messages: 2373
Registered: April 2006
Location: Surrey, UK

Senior Member

PostgreSQL is peculiar because it has the hierarchy server->database->schema->table instead of server->database->table. When the framework code connects to a server it is possible to change the default database (or "schema" in postgres) to whatever you choose, or even to construct a query which accesses tables in more than one database (or "schema" in postgres). For this reason when using postgres the "database" name *MUST* be hard coded in the config file, and it is only the "schema" name which is dynamic. Please refer to http://www.tonymarston.net/php-mysql/postgresql.html#databas e.connection for details.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Check for empty $schema in dml.psql.class.inc By: pdv on Wed, 06 February 2019 12:42
		Re: Check for empty $schema in dml.psql.class.inc By: AJM on Thu, 07 February 2019 04:49
		Re: Check for empty $schema in dml.psql.class.inc By: pdv on Thu, 07 February 2019 07:15
		Re: Check for empty $schema in dml.psql.class.inc By: AJM on Fri, 08 February 2019 05:11
		Re: Check for empty $schema in dml.psql.class.inc By: pdv on Sun, 10 February 2019 11:16
		Re: Check for empty $schema in dml.psql.class.inc By: AJM on Mon, 11 February 2019 04:43
		Re: Check for empty $schema in dml.psql.class.inc By: pdv on Tue, 12 February 2019 04:44
		Re: Check for empty $schema in dml.psql.class.inc By: AJM on Wed, 13 February 2019 04:19
		Re: Check for empty $schema in dml.psql.class.inc By: pdv on Wed, 13 February 2019 04:44
		Re: Check for empty $schema in dml.psql.class.inc By: AJM on Thu, 21 February 2019 18:30
		Re: Check for empty $schema in dml.psql.class.inc By: pdv on Mon, 25 February 2019 15:21
		Re: Check for empty $schema in dml.psql.class.inc By: AJM on Tue, 26 February 2019 04:39

Previous Topic:	convert_parent_id_to_child_id
Next Topic:	Frequently Asked Questions (FAQ)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jan 27 22:12:12 EST 2025

Total time taken to generate the page: 0.01090 seconds